Database::ExportTable |
||||||
Description | ||||||
The ExportTable
plugin supports two functions:
Export Table: Export data from a database-table using "RecordSet Export" or "BCP". In "BCP-mode" the BCP utility is used which is must faster then the internal "RecordSet Export". However, BCP needs to be available to be able to use this option. BCP is part of an SQL-server or client installation. Optionally a query can be used to select the data, in which case the data is not exported from the table. Export SQL Statement: Create SQL-statements to create the selected table and/or create an SQL-statement to create the indexes of the table. You can configure a regular-expression filter to select which of the indexes of the table should be exported to the SQL-statement. |
||||||
Export Table | ||||||
Options | ||||||
DSN
/ Server |
RecordSet
Mode: DSN (ODBC) or SQLserver which points to the database. |
|||||
Username |
Username for database connection. | |||||
Password |
Password for database connection. | |||||
Database |
Database name for ODBC connection. Not valid in BCP-mode. | |||||
Trusted
Connection |
BCP option. When checked a trusted-connection is established with the database-server and no username & password is required. | |||||
Disable
Logging |
When checked, all BCP logging is discarded. | |||||
Timeout
|
Timeout in seconds. If BCP is still running after the configured number of seconds it is assumed to hang and the BCP proces will be killed! | |||||
Use
BCP |
When checked, the table is exported in "BCP-mode" which requires the BCP utility. When unchecked the table is exported in "RecordSet-mode" which doesn't require any external utilities. | |||||
Tablename |
The name of the table from which the data must be exported. | |||||
Use
Query |
When enable, the configured query will be used to select the data to export. | |||||
Delimiter |
The delimiter
character(s) which separates the field-data. Note: in "Native Mode (bcp)" delimiter is not required/used. |
|||||
Outputfile |
The datafile to which the table contents will be exported. Existing files will be overwritten, except if the "Append" option is checked (only in RecordSet-mode). | |||||
Native |
When checked, the inpufile is assumed to be in "native BCP format". Only valid for BCP-mode | |||||
Append |
When checked, the exported data will be appended to the outputfile. Only valid for "RecordSet-mode". | |||||
Export SQL Statement | ||||||
![]() |
||||||
Options | ||||||
ODBC
/ SQLserver |
The driver to use to connect with the database. |
|||||
Tablename |
Name of the table to be exported. | |||||
Index
name filter |
Only indexes which names match this regular-expression filter will be exported. | |||||
Only
Create if Table/Index Not Exist |
If enabled, the statement will include an "IF NOT EXIST ...." clause to only create the table/index if it doesn't exist. | |||||
Create-Table
Statement |
If enabled, the "CREATE TABLE..." statement to create the selected table will be saved to the selected variable. | |||||
Create-Index
Statement |
If enabled, the "CREATE INDEX..." statement to create the indexes of the selected table will be saved to the selected variable. | |||||
Include
"IF (NOT) EXIST..." |
If enabled, the statement will include an "IF (NOT) EXIST .... (DROP {table|index})" clause.. |