Post reply

Sync Multiple Databases

  • May 3, 2010 at 11:10 am

    #144477

    Hi,

    I have one main database on which I used to do some changes.

    and on the same server I have around 20 databases, which I want to be in sync with the main database.

    I dont want data to be in sync with these databases.

    I just want structural changes to be in sync.

    Like adding / altering / deleting = > column / tables / procedures / views.

    I am also not sure whether can all changes be in sync , like

    1. If I add Full-text search in main database

    2. If I add job agent in main database

    Please sugest a good procedure / tool to Sync Multiple Databases.

  • May 4, 2010 at 3:43 am

    #1161674

    Abhijeet Dighe (5/3/2010)

    I just want structural changes to be in sync.

    Like adding / altering / deleting = > column / tables / procedures / views.

    DDL triggers can help you there, they provide the modified schemas of objects but during schema modification, you need to think about the data of tables.

    Need a good logical design to setup/approach this requirement.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • May 4, 2010 at 4:23 am

    #1161682

    Can replication be used?

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

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