Post reply

Is there any problem with Scripting SQL 2005 Publication?

  • October 26, 2009 at 6:52 am

    #216773

    Hi Everyone

    I have been informed by DBA of an organisation from whom we have purchased our product that it is a bad idea to script publication in SQL 2005. When you script up the publication in SQL2005 it doesn’t include all the necessary settings and you will find replication does not work properly.

    Does anyone know if there is any problem with creating publication scripts in sql server 2005?

    Any help will be much appreciated.

    Thanks in advance.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • October 26, 2009 at 2:37 pm

    #1070933

    As far as I know, NO. There are no problems. Just make sure that you modify the scripted file to use the right user, server names etc

    But double check. Test it out in a test environment.

    -Roy

  • October 27, 2009 at 3:12 am

    #1071073

    Thanks a lot again roy.

    I have used replication scripts so many times before and they seem to be functioning fine as far as all the required bits are changed to make it run on another server.

    I just wanted to get opinions on this before i can go back to our supplier and give them a bit of stick for conveying the incorrect information. 🙂

    Thanks again!

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • October 28, 2009 at 9:16 am

    #1071827

    I find that creating the replication scripts REALLY speeds up recreation publications. I do sometimes have to add things like passwords.

  • October 29, 2009 at 4:03 am

    #1072319

    Certainly.

    Thanks SQL DBA 808.

    Vivek Shukla - MCTS SQL Server 2008

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply