In our coding environment, like most, we have a development environment and a production environment. As we have been making the move to use more stored procedures and less queries, we have run into an issue where the procs do not get synchronized between the development (dev) and live server.
So the other day, I was talking with a friend of mine and we came up with a problem. We were both working on a project, and we ended up with disparate sets of data. The database schemas were the same, but I had inserted some data that he needed. I could have just sent him a SQL backup file, but he had data in his database that I did not have. So the only solution was to create INSERT statements for all the data that I had inserted, and for him to do the same. Obviously, this is a tremendous waste of time. So we came up with "CF_GenInserts"
A friend of mine at work sent me this link; it's pretty cool. Basically, you create your tables, columns, defaults, and relationships in designer mode, and once you are done, you tell it what language to generate the script in. You can also import your database from an XML file, and modify it, simlar to what you used to be able to do in the old(er) version of Visio.
http://ondras.zarovi.cz/sql/demo/
