Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-19 : 08:59:33
|
| Jordan writes "I sure hope you have answear to this one, because I can see a problem I am developing and I want out of it early.My enviroment is Win2000,SQL2000,ASP,IIS and we provide a service to our clients.In SQL server each client has there own database named let say 'CUST##########'. I have my own database named lets say 'DEVEL' in which I work off to develop new features.My exact problem is when I create new tables/stored procedures in my DEVEL database I need to 'replicate' those new tables/procedures to all the CUST########## databases.Thats my dilema. (sorry I know I spelled incorrectly)If there was a procedure I could run out of the master database and specify in Query Analyzer the name of the table/stored procedure that wouldn't be so bad either. It's just that I have around 25-30 client databases now, and real easily expect to have 100-500 within a year and if I have to cut copy paste for each database, I could waste a whole day just updating databases. And I do make my changes to the model database, so all new databases get the current db layout.Thanks,Jordan" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-19 : 14:39:46
|
| Jordan,Here's an article with a couple of ideas buried in it that might be of help: [url]http://www.sqlteam.com/item.asp?ItemID=751[/url].Another approach, which an old employer of mine took was to create a VB application what would query SQL Server for the list of databases, and give you a multiple-select box to pick them. It also would query a file folder for the list of scripts in it and let you pick the ones you wanted to apply. We would script all changes to the databases and then use this VB program to apply the updates. I think it was using isql to execute the scripts, but I'm not sure. Sorry I don't have the source code for you, but a good VB developer should be able to whip this up without too much effort.-------------------It's a SQL thing... |
 |
|
|
|
|
|
|
|
Updating Databases