Open topic with navigation

Learn more about Toad for SQL Server at Quest.com Find solutions and downloads at the Toad for SQL Server Support Portal

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.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create an import or export template

1. Select Tools | Export | Export Wizard.

   or

   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) checkbox 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. Select Tools | Export | Execute Export Template.

   or

   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