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 '09 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 '09 at 01:33 PM
It is but you'll need a third party tool like SQL Data Compare or Capacity Manager.
Oct 26 '09 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 '09 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 '09 at 03:17 AM
Seen: 413 times
Last Updated: Oct 26 '09 at 03:17 AM
Syntax error with Table Valued UDF when called from another DB
How to i get this as per below data
How to write NOT LIKE subquery with values pulled from table? with wild cards
Advantages & disadvantages of if db as simple and full recovery models?
If the servers will changes to RTM(sql server 2005) to SP2, What are the advantages will get?
How to add custom xml tags like in web.config in dtsconfig of SSIS 2005?,How to store custom tags in dtsconfig file for SSIS package in MSSQL2005?
Sql Query Help
Need help in Pivoting the Data
SQL Server 2005 vs SQL Server 2008 plan with Lazy Spool
Sql Server agent job failed with error msg14624