Options
Replacement for SQL Comparison SDK
RecySystems
Posts: 2 New member
Hello.
Which tool could work as a replacement for SQL Comparison SDK in the following scenario.
We use DLM automation for internal development.
Our customers have own databeses, that we update incrementally in bundle with our software. Sometimes incremental updates not working as expected, so we would like to check the database schema (and some master data) after update, that the updated state corresponds with the expected one.
Which tool can we use for this purpose as part of our setup / update?
Which tool could work as a replacement for SQL Comparison SDK in the following scenario.
We use DLM automation for internal development.
Our customers have own databeses, that we update incrementally in bundle with our software. Sometimes incremental updates not working as expected, so we would like to check the database schema (and some master data) after update, that the updated state corresponds with the expected one.
Which tool can we use for this purpose as part of our setup / update?
Best Answer
-
Options
way0utwest
Posts: 313 Rose Gold 1
The DLM cmdlets will verify the schema is as expected after deployment or they will return an error. If you really need to use a comparison, talk to sales/support about the SQL Compare command line.Editor, SQLServerCentral
Answers
Some of our customers does updates not really often. So we want to check the schema consistency (and some data, that we deploy with the database) after the update. With this check we want a guaranty, that the database is valid (we have over 600 tables and over 3000 views + triggers and jobs in our application).
DLM works fine on our CI at the moment.