MS SQL Data Wizard online Help
Data Pump wizard is a powerful tool for converting structure and data from any ADO-compatible source (e.g. MS Access or MS SQL database) to Microsoft SQL databases. It allows you to transfer tables, indexes, and foreign key constraints. With the wizard you can convert source objects directly to the target database or generate SQL scripts with objects definitions and INSERT statements to be used later. To run the wizard, use the corresponding link at the Home page.
To convert a database with its structure and data, complete the following steps:
See also: Templates, Data Pump Options.