Replacement for SQL Comparison SDK

RecySystems

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?

way0utwest

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.

way0utwest

DLM automation is the replacement for the SDK. What do you mean by the incremental update doesn't work? Do you not get an error report from DLM that helps? Or are you wanting the entire schema of the target (client) db?

RecySystems

The incremental updates work the most of time.

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.