deploying scripts to multiple databases and servers

[scimatic]

Does anyone know of any 3rd party software that allows you to execute sql scripts against multiple databases within multiple servers?

 

[JayKusch]

WOW ... alot of pushing there... lol

You could script out each database as needed and create a stored procedure for it. Put these store procedure in a working database for safe keeping and calling upon in the next steps.

You could then create a linked server to the desired servers.

Once that is in place, you may need to deploy a dreaded cursor and step through each of these servers.

As you attach to the server, you could then run the necessary SPs to manipulate the databases on that particular server.

Just an idea w/out having to purchase xtra software.

Thanks

J. Kusch

 

[scimatic]

I'm looking for something like what this company offers:

http://www.anosoft.com/

but more advanced. What I need is something where I can choose databases from different servers and deploy 1 or more sql scripts to them, but it needs to keep some sort of log so I know if any errors occurred during execution. Any suggestions? I don't care about price either.

Thanks

 

[JayKusch]

I wonder if Red Gate software may have what you need. The SQL Packager or SQL Toolkit just might be what you are looking for.

http://www.red-gate.com/sql/summary.htm

Thanks

J. Kusch