Post reply

Modify Published database

  • May 9, 2008 at 9:13 am

    #103490

    Our vendor gave us a script to apply changes to their application and a database that is being published. The script should add/modify tables, columns, etc. Can anyone tell me how should I handle the replication? Re-create it or ...?

  • May 16, 2008 at 8:17 am

    #816522

    Hi,

    I think this depends on the size of the database and the complexity of your replication.

    If you can, it's best to remove replication, make the changes and republish. But this would need distribution of a new snapshot...how quick that is depends on the size of the database/publication.

    If you can update publisher and subscribers so that they are still in synch after all the changes (and there are no changes happening on the database), you can add the publication with a no-synch option. This would mean and new snapshot would not have to be pushed out.

    HTH

    Graeme

  • May 19, 2008 at 9:15 am

    #817251

    Thank you for the tip!

Viewing 3 posts - 1 through 2 (of 2 total)

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