Post reply

SYNC Database automatically with model database whenever there are schema changes to the our model database

  • March 17, 2008 at 12:35 pm

    #124452

    We want to keep our client databases in SYNCH with our model database(only schema,objects). This should be done immediatley(not manually like using tools like sql compare) when we change the model database like alter table or create a new procedure. I have looked into Event Notification and DDL triggers all the examples show how to log /audit the changes but not apply the same change to remote databases. Any ideas on how we could do this?

  • March 19, 2008 at 8:03 am

    #791447

    I have not lloked at this, but could you use replication and only replicate the schema? Or through using DDL triggers you could generate scripts on the remote database servers that you then use a job to read and execute.

    Other than those options I don't think there is a way to do this within the SQL Toolkit.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

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

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