Online Documentation
SQL Server

Use bulk insert Enterprise version only.
Standard SQL inserts are a slow way to fill in data to the table. Microsoft SQL Server allows for a much faster way and Full Convert Enterprise takes advantage of this mode. Text file of predefined structure is built during conversion, allowing SQL Server to parse it at much greater speed, bypassing indexes and standard SQL parsing. Indexes and constraints are created afterwards. Speedups compared to standard inserts are often tenfold.
By default this option is enabled only if conversion is made on the machine where server is installed. If you have a network folder exposed at the server machine, you can specify it here. Speedups are not so drastic in this case as data has to travel through the network.
Note: bulk insert is automatically disabled when either SQL Logging is enabled, table contains BLOB fields, or when Table Settings are used.
Interpret dates in years 0000-0099 as 1900-1999
To be used when you have a legacy data with partial years.
Misc
Parse views as tables - sometimes you have access only to a certain view, not to full table. Use this option in that case. Enterprise only.







