Post navigation

SQL Script to generate data inserts for existing tables

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 was sent to me by e-mail but the comments mention the names of the creators (it’s NOT me). If you have a link to the original, please post it. Click here for the script file.