Database Experts

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.  

  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. ...