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 |
shiyam198
Yak Posting Veteran
94 Posts |
Posted - 2013-07-29 : 16:37:03
|
Hi,There is a maintenance database on every database servers. They have Stored Procedures and functions used for maintenance work. I know there is a SQL compare tool from Red Gate. but i don't have that tool. what is the efficient way to go about it?Regards,Shiyam |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-29 : 16:49:06
|
If you have Visual Studio Premium or Ultimate, it has a comparison feature: http://msdn.microsoft.com/en-us/library/dd193250(v=vs.100).aspx |
|
|
shiyam198
Yak Posting Veteran
94 Posts |
Posted - 2013-07-30 : 10:16:57
|
Thank you. I don't have Visual Studio, unfortunately. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-30 : 10:40:30
|
I can't think of a simple T-SQL based way of doing this comparison. The only thing that comes to mind is to script all objects in each database (Tasks -> Generate Scripts from the context menu in SSMS when you right-click on the database name), save the files to separate folders and then use a file comparison utility. I am not sure if the files will compare exactly because of datestamps etc. that may get inserted into the scripts generated. |
|
|
shiyam198
Yak Posting Veteran
94 Posts |
Posted - 2013-07-30 : 11:19:39
|
Thanks again James. Much appreciated. |
|
|
|
|
|