Replication scripts

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 4:39 pm

  #684145

  You can script the replication through Enterprise Manager and also can be done using SQL DMO.

  Script the replication when you are running on different server you need to replace the servername.

  Enterprise manager/Server name/tools/replication/Generate sql scripts...

   

  MohammedU
  Microsoft SQL Server MVP

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 4:42 pm

  #684147

  Script out the complete replication setup to a text file

  http://www.replicationanswers.com/Script5.asp

  Script out the replication setup to a series of files - one per replicated database

  http://www.replicationanswers.com/Script6.asp

   

  MohammedU
  Microsoft SQL Server MVP