Online Documentation for DB Extract for SQL Server

Databases section


This section of DB Extract template contains the list of the database objects specified for extraction, and particular extraction parameters.

 

The configuration parameters are listed below.

 

 

OutputFileName

The name of the result *.sql script file (if SingleFile = 0, see File Options section)

 

ArchiveFileName

The name of the result *.zip archive file (if SingleArchiveFile = 0, see File Options section)

 

 

The list of the objects specified for extraction is represented in the following format:

 

<ObjectType>Count

Stores the number of selected objects of this type, or equals to the 'ALL' string value (which means that all objects of this type are to be extracted)

 

TablesXX

Each parameter of this type stores the name of the table specified for metadata extraction (XX stands for the table unique identifier, e.g. Tables0 = TestDB.dbo.Account)

 

The list of objects that are included into the databases section is taken from the ExtractMetadataFrom parameter value (see Common Options section and Step 3 of the GUI application)

 

Next is list of tables to extract their data in the following format.

 

DataTablesCount

Stores the number of tables specified for data extraction, or equals to the 'ALL' string value (which means that data from all tables of the database are to be extracted)

 

DataTablesXX

Each parameter of this type stores the name of the table specified for data extraction (XX stands for the table unique identifier, e.g. DataTables0 = TestDB.dbo.Address)