transformations:bulkexportdb
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| transformations:bulkexportdb [2026/09/24 12:55] – fix line breaks roberto | transformations:bulkexportdb [2026/09/24 13:34] (current) – old revision restored (2024/11/20 00:07) roberto | ||
|---|---|---|---|
| Line 24: | Line 24: | ||
| |Connector< | |Connector< | ||
| |Table name< | |Table name< | ||
| - | |Column mapping |Select the method for mapping the dataset columns to the fields in the database table.\\ | + | |Column mapping |Select the method for mapping the dataset columns to the fields in the database table.\\ |
| < | < | ||
| Line 31: | Line 31: | ||
| ====Microsoft SQL Server advanced options==== | ====Microsoft SQL Server advanced options==== | ||
| ^Option | ^Option | ||
| - | |Check constraints|Without this option, any CHECK and FOREIGN KEY constraints are ignored, and after the operation, the constraint on the table is marked as //not trusted//. UNIQUE and PRIMARY KEY constraints are always enforced.\\ [[https:// | + | |Check constraints|Without this option, any CHECK and FOREIGN KEY constraints are ignored, and after the operation, the\\ constraint on the table is marked as //not trusted//. UNIQUE and PRIMARY KEY constraints are always enforced.\\ [[https:// |
| - | |Table lock|This option specifies that a table-level lock is acquired for the duration of the bulk-import operation. A table can be loaded concurrently by multiple clients if the table has no indexes and table lock (TABLOCK) is specified.\\ [[https:// | + | |Table lock|This option specifies that a table-level lock is acquired for the duration of the bulk-import operation. A table can\\ be loaded concurrently by multiple clients if the table has no indexes and table lock (TABLOCK) is specified.\\ [[https:// |
| \\ | \\ | ||
transformations/bulkexportdb.txt · Last modified: by roberto