SQL Server Data Export Utility
Version: 1.3.1
Released: 5/20/2008

DatabaseExport is an utility to export MS SQL Server data and objects. It was developed as an internal application to export data as INSERT statements from Microsoft SQL Server databases. It also handles exporting data into CSV files. We have added support to also export objects within the database, such as stored procedures and tables.

You can very easily script out the entire database, including all tables, stored procedures, and data. The data can be wrapped with IF NOT EXISTS, and can have INDENTITY_INSERT ON included. The objects can also have IF NOT EXISTS wrapped around the CREATE statements.

The product comes as a Windows MSI Installer, which will install the working application as well as install the source code to the DRIVE:\Program Files\asp.netSoftware\DatabaseExport\Source Code directory. This project is written in VB.NET, version 2.0. Because this project is open-source, feel free to update the code as you see fit, then send it back to us. We will get your updates added in with credit to you. There are several updates that we would like to see added.

Screenshots

Source Code

Server Connection

Select Objects

Choose File

Export Progress