Lets suppose i am having 2 database that is
Database1 and Database2
Then both datbases are same having same number of tables, sp's, vies and etc.
Then wht i have done is i have added two tables in database1 tb23 and tb24, and at the same time i have added one table out of these two table that is tb23 in the database2,
Now i want a querry by using that querry i am able to find out that how many objects are there that are present in database1 but not in database2. Basically i want to do comparison in between two databases.
ANY QUERRY, OR ANY TOOL by using which we can acheive this.....
HOW?
Dear Prashant,
Check this
http://msdn2.microsoft.com/en-us/library/aa833297(VS.80).aspx#CompareSchemasofTwoDatabases
For a 30 day evaluation version, you can use this.
Also check the Tablediff Utility in Books Online for SQL Server 2005 for comparing tables.
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
|||Check out RedGate SQLCompare.
http://www.red-gate.com/products/SQL_Compare/index.htm
No comments:
Post a Comment