Usage of SQL Server Schema Compare v1.21.0 extention

Question

Hello,

I am using ADS:

Version: 1.50.0 (system setup)

Commit: 49c73a84388731fec941dac8d938345ac16bd470

Date: 2024-11-17T22:41:05.327Z

VS Code: 1.82.0

Electron: 30.5.1

Chromium: 124.0.6367.243

Node.js: 20.16.0

V8: 12.4.254.20-electron.0

OS: Windows_NT x64 10.0.17763
I have to compare 2 tables in the same database. I installed and used this extension: SQL Server Schema Comparev1.21.0

I never used it before ... and I see that it allows to compare only databases but not tables.

My question:

1. could you suggest some workaround to use this extension for table comparison
2. could you suggest another ADS extension for tables comparison?

Thanks

Answer 1

why wouldn't you just use a full outer join query to compare?

Answer 2

Script both tables and save to file, and then compare the files in a good diff tool, for instance Beyond Compare.

Full disclosure: I am not affiliated with Scooter Software, the vendor of Beyond Compare. But I am a very satisfied user for more than twenty years.

Answer 3

Hi @Voldman, Eliya

How about using SQL Server Data Tools (SSDT) to compare the data that is contained in two databases.

See: How to: Compare and Synchronize the Data of Two Databases with SQL Server Data Tools.

You can compare the data in a source database and a target database and specify which tables should be compared. The data can be reviewed to guide a decision about which changes to synchronize. Then you would either update the target to synchronize the databases or export the update script to the Transact-SQL editor or to a file.

See this doc for more details: Compare and Synchronize Data in One or More Tables with Data in a Reference Database.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".