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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-12-23 : 05:06:58
|
| Dear All,I need to compare the 2 database for schema,objects,row data etc between the 2 databases.This is requirement for our new client can you please suggest any good tools which are there in the market to accomplish the same.Also is there any way we can do this by T-SQL queries.Please guide me and help |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-23 : 05:54:07
|
| I wrote a script to do this. (It might not do everything you need though - it doesn't compare data or programability objects, only the data schema).Give it a try:Forum post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136699Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
|
|
|
Data base comparision