Version control database schema the SQL Compare way from Red-Gate
Tags: Version Control, General, SQL Compare, Coldfusion
In my last post on Version Control Database Schema I spoke about how you can use the build.xml file to recreate you database from the generate schemas, since then I have been chatting with their Product Manager David Atkinson. One of the major problems I had with the last method was the fact that it failed with dependencies and constraints, and usually had to modify the order of the SQL files until it would not error.
David showed me something that I wasn't aware of and made it a little more automated in the process.
