Toad for SQL Server 8.1 - Installation Guide

Use Import and Export Templates

When importing or exporting data, you can save your current settings as a template. This is useful, for example, if you need to export customer data from both your production and test databases. Although Toad saves connection data with the template, you can change the connection when executing the template.

To create an import or export template

1. Do one of the following:

   • Select Tools | Export | Export Wizard.
   • Select Tools | Import| Import Wizard.
2. Complete the wizard, and make sure you select the Save template (can be run at a later time using automation) check box on the Save Settings as Template page.

To execute an import or export template

1. Create an import or export template.
2. Create a connection to the database you want to execute the template against.

3. Do one of the following:

   • Select Tools | Export | Execute Export Template.
   • Select Tools | Import | Execute Import Template.
4. When prompted, select whether you want to use the current connection, or the connection stored in the template.

Related Topics

Export Data with the Export Wizard

Import Data

Automate Tasks