Queued updating subscribers

The next screen asks whether you want to use the local server or a different server as the distributor (see Figure 1).

queued updating subscribers-7queued updating subscribers-4

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.

You must have an account to comment. Please register or login here!