Using configuration files (templates)
Data Export for SQL Server allows you to store its configuration settings in external *.cfg files if you need to perform the data export process repeatedly.
Data Export templates are saved within the Save template options dialog. To open this dialog, press the Tools button and select the Save Template popup menu item.
Note: You can save changes to a template without recalling the save dialog using the Save Template As popup menu item.
Specify the template file name and select its location using the button which calls the Save As... dialog.
If you need to repeat data exporting process with the same or similar settings later, it is reasonable to save all the settings you entered on the Start of data export process step of the Wizard.
Data Export templates are loaded within the Open template dialog. To open this dialog, press the Tools button and select the Load template popup menu item.
If necessary, you can reload a template using the Reopen configuration popup menu item of the Tools menu.
When the configuration file is loaded, you can browse (or change the settings, if necessary) in all steps of the wizard.