Relative Content

Tag Archive for sql.netdatabasemigrationschema

Database schema migration – rules for generating SQL update scripts

Our team uses “brokers” (something akin to an ORM) responsible for mapping objects to SQL, aimed towards specific database providers. We’re currently implementing a migration mechanism that would compare the project’s data model (compiled at runtime from a collection of xml’s) with the model read from an instance of some supported database, so that we may list the differences and generate a set of commands that would bring this target database up to speed with the evolving project model.