migrating a database to another programmatically
posted 6 years ago
There are plenty of off the shelf, comercial solutions but not many via an embedded library. In general, though, I've found it doesn't take much work to write one yourself for a specific task. If you use the meta data API, you can read a database and create a file of SQL create/insert commands, formatted for the new database. Then just call a bulk script on the file and load it into the new database. In general, converting a database is non-trivial process so doing it yourself gives you a lot of control of what goes to what.