I have two databases - Database1 and Database2. The name of your database can't be [D: DATABASE1.MDF], that may be the path to the physical data file. So the complete table name (3 part name as in db.schema.table) is [DATABASE1].[dbo].[Table1].

• Compare Sql Server Databases
• Database Compare Sql Server

SQL Server Data Tools, also known as SSDT, built over Microsoft Visual Studio can be easily used to compare the data in two tables with the same name, based on a unique key column, hosted in two different databases and synchronize the data in these tables, or generate a synchronization script to be used later. I need to compare two databases (e.g. Development DB and Test DB) to make sure they are 100% identical. I need to compare those system data in Development and Test databases as well. SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases.

Compare Sql Server Databases

Database Compare Sql Server

If it's a one time task, use the. It's a great tool and it offers a trial version. If you have Visual Studio Professional you should also have inside it. It's another great tool to compare data and schema. If you don't have access to any other tools to compare the data in two tables, I would use tablediff.exe, which is included in the SQL Server installation. You'll find it in the SQL Server program path. Details, on MSDN.