Guide line for moving replication -- sql server replication

Paul
8/26/2005 2:15:01 AM

We are planning to move SQL server from SBS to windows server 2003.
This means that we are setting up a server and will backup the existing DB
and Restore it on the new server.
I need require assistance in the setting up of replication to/from XXX
server on the new server same as we are using on SBS server.
Can you please provide a suggestion on what needs to be done and an estimate
the jobs required?

--

Hilary Cotter
8/27/2005 7:24:10 AM

The best approach is to script out the publications on the SBS server. Edit
the script and remove all entries to @distribution_job_name,
@logreader_job_name, @snapshot_job_name (remove the commas, the parameter
name, and its value). Adjust the value of the @subscriber parameter if
necessary.

Then drop the subscriptions and publications on the SBS server. Then apply
the edited script on the new publisher.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : Guide line for moving replication