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
 General SQL Server Forums
 New to SQL Server Programming
 Compare databases
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shiyam198
Yak Posting Veteran

94 Posts

Posted - 07/29/2013 :  16:37:03  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3326 Posts

Posted - 07/29/2013 :  16:49:06  Show Profile  Reply with Quote
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
Go to Top of Page

shiyam198
Yak Posting Veteran

94 Posts

Posted - 07/30/2013 :  10:16:57  Show Profile  Reply with Quote
Thank you. I don't have Visual Studio, unfortunately.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3326 Posts

Posted - 07/30/2013 :  10:40:30  Show Profile  Reply with Quote
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.
Go to Top of Page

shiyam198
Yak Posting Veteran

94 Posts

Posted - 07/30/2013 :  11:19:39  Show Profile  Reply with Quote
Thanks again James. Much appreciated.
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.05 seconds. Powered By: Snitz Forums 2000