High speed data transfer utilities

The Automator populate event uses Bulk Copy to populate and update the database. Most database software comes with a high speed data transfer utility generically referred to in this document as Bulk Copy.
 Bulk Copy is much faster than SQL insert and enables the transfer of native data types (as opposed to character strings). Keep in mind that Bulk Copy affects the recoverability of your database because it uses non-logged operations.

Note

Database backups plus Visualizer input file archives are more reliable than backups plus transaction /recovery /redo logs. 

The following databases support Bulk Copy:

  • Microsoft SQL Server
  • ORACLE

Note

If the same machine serves as both the server and client, the default memory allocations by SQL Server might cause excessive paging. Refer to your SQL Server documentation for tuning information

Related topic

Installing


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*