Wednesday, August 29, 2012

Microsoft SQL Server 2005/2008R2:SQL Alias-User friendly names for connecting SQL Server

For More information about SQL Alias,Read this

Follow this steps to create sql alias.

1.Just Go to -->Programs-->SQL Server 2005/2008R2-->Configuration Tools-->SQL Server Configuration Manager-->

 

Click on SQL Native Client 10.0 Configuration.


 

 
 Click on Aliases

Right click -->New Alias.

 

Fill Information about SQL Connection.

Alias Name:Server1

Port No: 1433

Protocol :TCP/IP

Server:(Instance Name)192.168.0.16\SQL2005


Click Ok.


Alias created.

Use Alias name instead of Original Connection Settings.

 



Wednesday, August 22, 2012

Database Experts:Easy way to Microsoft Sql Server 2005 to SQL Server 2008 R2 Database Snapshot Replication

  Microsoft Sql Server 2005 to SQL Server 2008 R2 Database Replication.





For More information about snapshot replication read this,Snapshot Replication

Follow this step to do replication.

Database Server Info: SQL Server 2005 Instance:Bhavu
                                : SQL Server 2008\R2 Instance:Bhavu\R2


1.Connect to SQL Server 2005.

2.Create Distributor.

Go to SSMS_2005-->Replication-->Configure Distribution.









Use UNC Path for Snapshot.

\\192.168.0.242\Database Backup\RepData

















Wait for Process Completion.




2.Create Publisher.

Go to SSMS_2005-->Replication-->New Replication-->

..


Select Database to publish.






Select Publication Type.This is the Snapshot Publication.




Select Articles (Objects) that need to Publish












Schedule Snapshot agent.




















Wait for Process Completion.




3.Create Subscriber.

Go to SSMS_2008\R2-->Replication-->Local Subscription






































Wait for Porcess Completion.