Online Documentation for DB Extract for SQL Server

File Options section


Section [#FileOptions#] stores values set on Step 7 of Wizard application.

 

The configuration parameters are listed below.

 

 

SingleFile

0 = Create a separate file for each of the databases (see Databases section)

1 = All metadata and data are extracted into one file

 

SingleFileName

Stores the file name (if SingleFile = 1)

 

AddDateTimeToFile

0 = Do not add the current date and time to the file name(s)

1 = Add the current date and time to the file name(s)

 

AddDateTimeTypeFile

0 = Date will be added to the filename

1 = Time will be added to the filename

2 = Datetime will be added to the filename

 

 

CompressFiles

0 = Do not compress files

1 = Compress files

 

SingleArchiveFile

0 = Create separate archive file for each of the databases (see Databases section)

1 = Compress all the script files into a single archive file

 

SingleArchiveFileName

File name (if SingleArchiveFile = 1)

 

SingleArchiveVolumeSize

Sets the size of an archive volume in bytes by default, kilobyte if the value is followed by 'K' and megabyte if the value is followed by 'M'.

AddDateTimeToArc

0 = Do not add the current date and time to the archive name(s)

1 = Add the current date and time to the archive name(s)

 

AddDateTimeTypeArc

0 = Date will be added to the archive name

1 = Time will be added to the archive name

2 = Datetime will be added to the archive name

 

 

InitialDir

The path to the directory where the script files are to be saved by default

 

AddFolderWithDate

0 = Do not create a folder with the current date and time as the name inside the default directory (which is specified in the InitialDir parameter)

1 = Create a folder with the current date and time as the name inside the default directory (which is specified in the InitialDir parameter)

 

AddDateTimeTypeFolder

0 = Date will be added to the folder name

1 = Time will be added to the folder name

2 = Datetime will be added to the folder name