Replication Script

• jeca73

  SSC-Addicted

  Points: 428

  More actions

  January 30, 2002 at 6:56 am

  #78509

  Hi,

  I set transactional replication on 2 sql servers 2000.But I need to generate script of that replication and install it on 2 another servers.Hoe to do that?

  Thanks a lot,

  Jelena

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  February 2, 2002 at 7:36 pm

  #423009

  There is an option to script it all out. Try right clicking the publication in SQL2K. Then just change the DB name using search/replace.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• jeca73

  SSC-Addicted

  Points: 428

  More actions

  February 4, 2002 at 2:19 am

  #423037

  Thanks a lot, I succeed.

  Jelena