Phillip Gagnon - MSSQL

Copying Stored Procedures From one server to another

Tue, 26 Aug 2008 21:52:00-0400

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. [More]

CF_GenInserts - Way Cool Custom Tag

Thu, 13 Sep 2007 13:59:00-0400

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" [More]

Draw your database in any language

Sun, 26 Aug 2007 12:13:00-0400

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/