Have you ever had a situation where you were deploying a SQL database and need to populate it with some basic information only to find out that MS SQL doesn't provide an easy way to do this? So you search the internet for hours on end only to find a couple obscure scripts that are so manual you might as well just write it yourself. Well here is your answer, SQL Buddy, a GUI driven interface to script those defaults. SQL Buddy is so easy to use you'll wonder how you ever did without it. Here's how it works:
Step 1 - Set up your connection string to the database
Step 2 - Choose the tables you want to script. You can also choose to add a Truncate statement to the beginning of each table.
Step 3 - Click Create Script and save the file where you want.
New - Script tables to seperate files
That's it! Now scripting defaults are as easy as 1,2,3.