How to use "Row Diff" - DBUpdateTool - Excel

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

For the selected row, the cell and DB data are compared, and if there is a difference, the background color of the cell is changed to express the difference. [Multi rows can be selected]

1. The explanation starts from the following database status.

DBUpdateTool_UpdateRow_105_Expansion_en DBUpdateTool_UpdateRow_106_Expansion_en

2. In "Microsoft SQL Management Studio", enter "2020-10-21" in "DeletedDate" and commit.

SQL_Server_Management_Studio_108_Expansion_en

3. The contents of the database have changed, but the previously updated data remains on Excel. Now, let's do "Row Diff".

DBUpdateTool_RowDiff_101_en

4. The process is complete and a message is displayed.

DBUpdateTool_RowDiff_102_en

5. The background color of the "G2" cell has changed. If there is a difference between the database data and the Excel data, the background color of the cell will change in this way.

DBUpdateTool_RowDiff_103_Expansion_en

6. If you look closely, a comment is set in the "G2" cell. Hover your mouse cursor over the "G2" cell to see the content of your comment. Although it is described as "(null)" on the Excel cell, it indicates that the actual database data is "2020-10-21 00:00:00.000". This is the state where there is a "difference" between Excel and the database.

DBUpdateTool_RowDiff_104_Expansion_en

Lasis Corporation