J
James Palmer
Guest
We use ANT and PCT. PCT is a free plugin for ANT to provide OE functionality to it. It's basically an automation wrapper around the utilities that Gus mentions above, but it does make it a lot easier, and you can build whole processes to run through. One of the things we have done is to create a script that will create a dummy database with the new schema, automatically create a delta to your real database, and then load that delta. This has a lot of advantages, not least of all not having to keep hundreds and hundreds of delta dfs in source control so that people can migrate from one version to another.
Continue reading...
Continue reading...