Change Database Settings

image\DatabaseSettings.gif

 

  • Click Tools/Options/Database Settings menu item.
  • Make changes to any of the settings displayed on the form.
  • To Save changes:
    • Click Apply to save changes and remain in the options form.
    • or
    • Click OK to save changes and return to main form.
    • or
    • Click Settings/Accept menu item to save changes and return to main form.
  • To Cancel changes that have not yet been saved:
    • Click Cancel button.
    • or
    • Click Settings/Cancel menu item.
  • To back out changes made since last save:
    • Click Reset button.
  • To restore the original installation settings:
    • Click Settings/Restore.
    • CAUTION: This will overwrite any settings changes you have made since the application was installed.
  • To print the settings:
    • Click Tools/Options/Settings/Print Preview or Tools/Options/Settings/Print.
    • Click Tools/Options/Settings/Page Setup to adjust the format of the output

 

Valid Values for Database Settings

 

Database Setting

Description/Notes

Valid Values

Default Value

Batch Size For Data Imports And Exports

This number will be overridden by the batch size limits for individual database providers.

Number

200

Batch Size For Random Data Generation

Specifies number of random values to generate each time a new set of values the application can use is produced.

.

Number

50000

Default Data Grid Export Folder

Default folder for storing output from data grid exports..

Valid Windows file path
or
Blank

C:\Users\ YourUsername \Documents\pfApps\pfDataExtractor\DataExports\

Default Input Database Connection String

Default connection string to use when the Default Input Database Type for a data source is set on one of the application’s data source drop-down lists.

String value.

Blank

Default Input Database Type

Default database platform to display when form with a data source Database Type drop-down list is first shown.

image\DatabaseProvidersList.gif

 

Blank

Default Output Database Connection String

Default connection string to use when the Default Output Database Type for a data destination is set on one of the application’s data destination drop-down lists.

String value.

Blank

Default Output Database Type

Default database platform to display when form with a data destination Database Type drop-down list is first shown.

image\DatabaseProvidersList.gif

 

Blank

Default Query Definitions Folder

Default folder for saving SQL query definitions.

Valid Windows file path
or
Blank

C:\Users\ YourUsername \Documents\pfApps\pfDataExtractor\QueryDefs\

Overwrite Output Destination If Already Exists

Set this to true if you want any prompts for overwriting files or tables to be set to true by default.

Checked/Unchecked

(True/False)

True

Show Installed Database Providers Only

Set this to true if you want database platform drop-down lists to only include data providers that are installed on the current system.

NOTE: If you list data providers that are not installed and then select one of the uninstalled providers, you will generally get error messages when you try to use the uninstalled providers.

You might be able to define saved connections strings (Connection String Manager Overview) for the uninstalled providers but you will not be able to read or write data using those providers.

Checked/Unchecked

(True/False)

True