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 |
|
cyorka
Starting Member
7 Posts |
 Posted - 2005-05-25 : 13:52:10
|
| I have mutiple databases on several SQL Servers that need updating on a periodic basis. All DBs have the same schema. Currently, I manually run the update script in each DB. The update scripts typically create new tables, add/drop columns, executes stored procedures, and update data. Are there any third party tools that can simplify this type of job, or is there a way to do this easily using existing SQL Server tools. Any recommendations you have is appreciated. |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2005-05-27 : 07:43:08
|
| Try linking the servers to one sql server, you can then have a job schedule on that server, calling the stored procs on each servers doing their update stuffs.Donn Policarpio |
 |
|
|
cyorka
Starting Member
7 Posts |
Posted - 2005-05-31 : 13:48:25
|
| If I am understanding you correctly, you're suggesting that I create a stored procedure, with all of my updates, on all DBs on all servers, then have one server call that stored procedure. Correct? If so, then is there an easy way to create/update the stored procedure without having to do it manually inside each database? Thanks for your advice. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-31 : 15:29:44
|
| I would create a batch file that uses osql.exe to execute your script.Bat file:osql.exe -E -SServer1 -iC:\SomeScriptFile.sqlosql.exe -E -SServer2 -iC:\SomeScriptFile.sqlosql.exe -E -SServer3 -iC:\SomeScriptFile.sqlSomeScriptFile.sql:USE SomeDatabaseGO...Tara |
|
|
|
cyorka
Starting Member
7 Posts |
Posted - 2005-06-01 : 09:17:25
|
| Thanks for the reply Tara. I'll try it out. |
|
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2005-06-01 : 15:08:50
|
quote:
Originally posted by cyorka
If I am understanding you correctly, you're suggesting that I create a stored procedure, with all of my updates, on all DBs on all servers, then have one server call that stored procedure. Correct? If so, then is there an easy way to create/update the stored procedure without having to do it manually inside each database? Thanks for your advice.
You dont have to. You just need to call the existing SPs on each servers from one server. That is if you have a link setup between them. Anyway, what Tara had suggested is a better approach since it would get you out of headache linking the servers. :)Donn Policarpio |
|
|
|
cmoore
Starting Member
1 Post |
Posted - 2005-06-17 : 17:57:20
|
| Did you come up with a workable solution? |
|
|
|
|
|
|
|
|
Multiple DB updates