Entries Categorized as 'database'

Database Schema Compare & Upgrade

Date July 10, 2008

I spent a few days playing with Ruby on Rails a while back.  During the learning experience, there was one particular feature that I really liked.  It was the database migration scripts that get automatically generated for you.  I always wished I had something like this in the windows (asp.net) world.  It turns out there […]

SQL Script to generate data inserts for existing tables

Date May 10, 2007

Here is a great sql script that will look at your table and generate a script to insert all the data. This is very useful when moving databases or when you want to create a database setup in your application with some default data. Note that I haven’t tried this procedure and it […]

Close
E-mail It