CODEWITHSUNDEEP
sqlsql-server
carlosm
carlosm

Reputation: 755

Compare two tables with different schema in SQL Server

I have two tables in different databases with different schema, how can I compare them both?

Let's say I have the DB1 with the table history.Table1 and another DB2 with the same table but in a different schema, backup.Table1.

Now I need to compare what's different besides the schema name obviously.

Upvotes: 0

Views: 1507

Answers (1)

Dan Cundy
Dan Cundy

Reputation: 2849

Try SQL Compare from Redgate. They allow you to compare pretty much everything from the actual data to the schema.

I dont believe there is any native functionality in sqlserver.

Compare SQL Server schemas and deploy differences fast

Compare and deploy SQL Server database contents

Upvotes: 1

Related Questions