| Author |
 Topic  |
|
|
Developer31
Starting Member
3 Posts |
 Posted - 12/21/2012 : 12:32:25
|
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
5152 Posts |
Posted - 12/21/2012 : 12:46:49
|
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. |
 |
|
|
Developer31
Starting Member
3 Posts |
Posted - 12/21/2012 : 13:35:46
|
| 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 |
|
|
|
echernob
Starting Member
USA
4 Posts |
Posted - 12/21/2012 : 13:57:06
|
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. |
|
|
|
Developer31
Starting Member
3 Posts |
Posted - 01/02/2013 : 12:14:04
|
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! |
|
|
| |
Topic |
|
Connect to multiple databases
