Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Work with Data > Use Import and Export Templates

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

Import Data

Automate Tasks