User Tools

Site Tools


transformations:bulkexportdb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
transformations:bulkexportdb [2026/09/24 12:55] – fix line breaks robertotransformations:bulkexportdb [2026/09/24 13:34] (current) – old revision restored (2024/11/20 00:07) roberto
Line 24: Line 24:
 |Connector<sup>*</sup>|Select or create a configured connector matching the //Database type// chosen above.| |Connector<sup>*</sup>|Select or create a configured connector matching the //Database type// chosen above.|
 |Table name<sup>*</sup>|Select the table to export to.  Click the //refresh// button if the table list does not automatically populate, or needs to be updated.| |Table name<sup>*</sup>|Select the table to export to.  Click the //refresh// button if the table list does not automatically populate, or needs to be updated.|
-|Column mapping |Select the method for mapping the dataset columns to the fields in the database table.\\  Options: //Automatic// (export to database columns with the same names) or //Explicit// (manually map the dataset columns on the left to the database fields on the right; use the "Map possible" link to auto-select matching field names).|+|Column mapping |Select the method for mapping the dataset columns to the fields in the database table.\\  Options: //Automatic// (export to database columns with the same names) or //Explicit// (manually map the dataset\\ columns on the left to the database fields on the right; use the "Map possible" link to auto-select matching field names).|
  
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
Line 31: Line 31:
 ====Microsoft SQL Server advanced options==== ====Microsoft SQL Server advanced options====
 ^Option  ^Description ^ ^Option  ^Description ^
-|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://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15#check_constraints|More on this 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://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15#check_constraints|More on this option...]]| 
-|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://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15#tablock|More on this option...]]|+|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://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15#tablock|More on this option...]]|
  
 \\ \\
transformations/bulkexportdb.txt · Last modified: by roberto

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki