Hi ,How to compare the two database, and get the different tables,store procedures.it is possible in SQL 2005.Any one can help me.
Oct 26, 2009 at 03:17 AM
If you have visual studio 2008 database team edition and the data dude plugin - this has a compare tool for data and schema very similar to red gates tool
Nov 25, 2009 at 01:33 PM
It is but you'll need a third party tool like SQL Data Compare or Capacity Manager.
Oct 26, 2009 at 04:25 AM
you can query the INFORMATION_SCHEMA view for the information you want.
Or you can also check out OpenDBDiff at http://opendbiff.codeplex.com/
Oct 26, 2009 at 04:24 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Oct 26, 2009 at 03:17 AM
Seen: 513 times
Last Updated: Oct 26, 2009 at 03:17 AM
problem with joins
Analysis services port?
Can the way this statement is written speed the query up or should I look at table design?
Totals across a rows columns and potentialy multiple rows
SQL Server 2005 cluster group not coming online
Deploy Sql Server Database along with Sql Server installation with vb.net application set up
How to copy logins/permissions from one server to anathor server?
Setup problem - unable to generate ODBC DSN
Update Else Insert Procedure
Unable to restore from transaction log into a different server