On the server where the existing replication is:
- Right-click the publication (in SSMS, Replication: Local Publications) and select Generate Scripts...
- Select To Create or Enable the Components
- Choose file location and Save
- OK and Close
On the server you want to copy it to:
- If the server has never had replication before, manually create and delete a test publication (right-click Local Publications & select New Publication, choose some random stuff, then right-click the test publication and Delete). This will ensure the distribution database is created along with other stuff needed for replication
- Open the script, replace the servers and logins as appropriate
- Run on the target server
No comments:
Post a Comment