In Visual Studio 2010 do you have the ability to compare the data of a database between 2 databases. I wanted to use this to copy data from one database to another. These databases have the exact same
Note for bounty: please answer only if you know a tool that can monitor what changes in the same db, don\'t mention tools that compare 2 dbs. A visual tool, like Embarcadero Change Manager is apprecia
When performing a schema compare having db_owner rights on the target database results in the following error:
When you need to compare two tables to see what the differences are, are there any tools or shortcuts you use, or do you handcode the SQL to compare the two tables?