.net - Programmatic database structure rollout -
i have definition datamodel , let application check , sync @ startup.
unfortunately cannot find product out there doing hear if know 1 or if have recommendations how solve problem.
the solution think of: application reads definition (an xml file example) @ startup , compares db structure. if different generates alter table
statements , adopts. might create default records in tables if missing. , should support multiple rdbms (ms sql, oracle, db2, etc.) , run in .net.
doing hundreds of sql scripts , rollback-scripts seem kind of unpractical , error-prone me.
i can start programming myself maybe there out there quite pretty?
Comments
Post a Comment