Download: PowerSQL v0.0.1
This is the official page of a small (ongoing) utility I made some time ago that allows you to dump SQL Server table data onto SQL/Text files. It is really easy to script and backup your data while mantaining referencial integrity. I’ve finally made it available along with my recent blog structure changes. Although it isn’t finished, it does its job pretty well, so it will make your life easier.
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 text files
- Set file size limit
- File per table option
- Maximum file size setting allows you to generate several, smaller, files
- SQL Views and Stored Procedure viewer and editor
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…
Screens:
Enjoy this free utility. Don’t forget to leave feedback.
