V
V
VMesser2021-05-20 14:08:40
Data Comparison
VMesser, 2021-05-20 14:08:40

How to organize a mass comparison of HP texts in the database with their versions in text files?

1. There are HPs in MSSQL
2. There are their versions in files (80 pcs)
3. It is necessary to run through all HPs with the least effort and see their diffs.

Obviously, for starters, there must be some kind of shell that can watch diffs.
It specifies the path to the files on the disk.
HP from the database are taken directly, or you first need a script for bulk uploading to text files. In this case, you need a mass comparison of 80 files. For example, by matching names.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
C
ComodoHacker, 2021-05-20
@ComodoHacker

Of course the script for uploading to files. There are a lot of great tools for comparing files, such as KDiff3.
Or in SSMS RMB based, Tasks, Generate Scripts.

D
d-stream, 2021-05-20
@d-stream

Well, maybe someday you should think about a version control system.
The same gitlab, svn, etc.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question