SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Other Development Tools
 Connect to multiple databases
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Developer31
Starting Member

3 Posts

Posted - 12/21/2012 :  12:32:25  Show Profile  Reply with Quote
We have a dev, prod, qa enviroment in our company. For each of these environments, I need to run a set of sql commands(takes a long time). What would be the best way to do it, while maintaining the history of executions.


Also, what is the best tool for connecting to sql and sybase database.

Edited by - Developer31 on 12/21/2012 12:41:56

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/21/2012 :  12:46:49  Show Profile  Reply with Quote
You can use SQL Server Management Studio - see here. But that may not give you any history or logs unless you do that by other means.

Other possibilities that I can think of are to use a Powershell script, or SQL Server Integration Services.
Go to Top of Page

Developer31
Starting Member

3 Posts

Posted - 12/21/2012 :  13:35:46  Show Profile  Reply with Quote
Thanks sunitabeck! I'll take a look at SQL Server Management Studio. It will be a good start!

Edited by - Developer31 on 12/21/2012 13:38:39
Go to Top of Page

echernob
Starting Member

USA
4 Posts

Posted - 12/21/2012 :  13:57:06  Show Profile  Reply with Quote
Try Concurrent Database Manager (CDM) at www.esctradingsystems.com

CDM not only allows users to run the same query against multiple servers but also keeps history of the original requests with the results.

In addition, CDM offers you a variety of other features including C# code generation from DB objects, unique SQL Query Catalog, protection against running the same query multiple times, etc.
Go to Top of Page

Developer31
Starting Member

3 Posts

Posted - 01/02/2013 :  12:14:04  Show Profile  Reply with Quote
The tool CDM is really good.. I tried it and found that it has lot of features apart from maintaining the history and running the concurrent queries.. We needed to generate C# classes & data contracts from tables. This tool generated it too.. Awesome stuff!

Thanks echernob!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000