MS SQL Data Wizard is a powerful Windows GUI utility for managing your SQL Server data. It includes the following modules:

Data Pump
• Converts schema and data from any ADO-compatible database to SQL Server.
• Transfers tables, indexes, and foreign key constraints.
• Migrates source objects directly to the target database or generates SQL scripts.

Data Import
• Imports data from the most popular formats including Excel, Access, CSV, DBF, XML, text files, and also ODBC data sources to SQL Server tables.
• Includes Graphical Builder to map source file columns to target table fields in a few mouse clicks.
• Uses bulk loading commands to speed up the import process.
• Lets you to adjust data formats, empty target tables, execute custom SQL scripts, etc.

Data Export
• Exports data from SQL Server tables, views and queries to the 17 most popular file formats including MS Excel, HTML, XML, PDF, etc.
• Allows you to fully customize output files including header and footer, fonts, colors, data formats, encoding, etc.
• Supports Office 2007 file formats natively.

ASP.NET Generator
• Creates a full set of ASP.NET scripts for working with SQL Server tables, views and queries through the web.
• Allows to create webpages of your own style: color scheme, images, fonts, etc.
• Protects generated scripts with advanced security settings.