I made available a small utility that allows you to script SQL Server data onto sql/txt files. It’s an old tool I used on several real world scenarios and it worked pretty well. It saved me a lot of time on many ocasions.

Although it isn’t finished, I thought of posting it so that you can save some time as well. Feel free to comment and don’t forget: use it at your own discretion.

Some of the features included are:

• SQL Server 2000 and 2005 support (2008 version’s new datatypes are yet to be added)
• Lists database tables, stored procedures and views
• Shows table schema info
• Dumps SQL Server table data onto configurable sql/txt files
• Set file size limit
• File per table option
• Maximum file size setting allows you to generate several, smaller, files
• View and Stored Procedure viewer and editor

From the PowerSQL homepage: “Keep in mind that this is a small utility I’ve made for my daily usage, and It’s still buggy, so use it at your discretion. I’ve used it successfully for several times in big production databases, but there’s allways room for error. Leave some feedback if you encounter urgent bugs, I’ll try to fix them. In the meantime I’ll try to get the time to make it a v1…”

Check out PowerSQL Homepage  to download, and don’t forget to leave some feedback.