Updating Multiple Databases Same Time

[jalbao]

I have an app that requires that each customer have thier own database. Each database will contain the same tables/fields etc. When I create a database for a customer, it will be duplicating the 'Model Database'.

My question is, if i need to make changes to the 'Model Database', how can I make the same changes to each of the databases that were created BEFORE I made the change to the Model, without having to manually change each existing database.

TIA

 

[cdukes]

Create a script to perform the database change and run it on each of the databases before running it on the Model database.

hope this helps,

Chris Dukes

 

[jalbao]

thanks for the response chris -

are you implying that i will have to do two separate updates - one for the customer databases and one for the model database..

 

[cdukes]

Unfortunatly, Yes as far as I know.

You could have a look at replication, but that is a whole new ball game.

Chris Dukes