Database Schema Validation - deployable/compilable
- by boomhauer
Looking for a tool that will allow building database schema validation that can be compiled into a standalong tool or as a module to be used in another application.
The scenario is - a client/server application that is sold to customers, and maintained through service releases. The service releases include database scripts to updated the database with any schema changes etc.
However, since this is a database and the customer could either
run upgrade scripts incorrectly, or
tinker around and mess up something in the DB
I would like to have this tool available with each release so we can verify the struture, and possibly some data, is valid. Also to have it available for remote debugging when a customer has a service ticket.
Schema compare tools I've researched work great for comparing local databases, but I haven't seen something that can generate something that is deployable with our application.
Thanks!