The next screen asks whether you want to use the local server or a different server as the distributor (see Figure 1).
Second, the Add button allows you to add a SQL Server or Oracle publisher.
Following a wizard isn’t difficult, but fewer wizard screens certainly make replication setup quicker.
As a rule, replication wizards in SQL Server 2005 are nearly 50% shorter than those in SQL Server 2000.
For this example, I’ll use the same instance as both publisher and distributor.
The next screen allows you to specify the snapshot folder where data and schema of the published database will be stored (see Figure 2).
In Microsoft SQL Server, you can replicate data and schema changes from one database server to another.