How to use "Get Diff" - DBUpdateTool - Excel

... by Hi-Neko in Excel DBUpdateTool October 24, 2020

Compare the data in the DB with the existing data in the Excel sheet and get the records that do not exist in the Excel sheet.

1. Check the data in the current table in "Microsoft SQL Server Management Studio".

SQL_Server_Management_Studio_110_Expansion_en

2. Now, there are two rows of table data in Excel. However, there are 3 rows of data in the database, and there is a difference between the data in the database and the data in Excel.

DBUpdateTool_GetDiff_101_Expansion_en

3. Click the "Get Diff" button of "DBUpdateTool" in the "Add-ins" tab of Excel.

DBUpdateTool_GetDiff_102_Expansion_en

4. The process is complete.

DBUpdateTool_GetDiff_103_en

5. The data of the table confirmed in advance in "Microsoft SQL Management Studio" is displayed on Excel. As you can see, the Excel data has increased from 2 rows to 3 rows.

DBUpdateTool_GetDiff_104_Expansion_en SQL_Server_Management_Studio_110_Expansion_en

Lasis Corporation