Client Tools Guide › File Menu › Configure Database Connection Details › Configure Bulk Insertion of SQL Data

Configure Bulk Insertion of SQL Data

The Bulk Insert option writes data to a temporary SQL file. This option speeds the process of saving data, and allows you to continue working while the SQL database reads data from the file.

The SQL Server must have read access to the shared folder in which the temporary file is stored during the save process.

Note the following:

• To use bulk import when Microsoft SQL Server hosts CA GovernanceMinder databases, assign bulkadmin or sysadmin privileges to the CA GovernanceMinder database user.
• The CA GovernanceMinder server and the Microsoft SQL Server must be in the same domain.

To configure bulk insertion of SQL data

1. In a CA GovernanceMinder client application window, click File, General Settings.

   The Settings dialog appears.

2. Click the SQL Connectivity tab.

   Select the Bulk Insert option.

3. Select one of the following options:
   • When the SQL Server is located on a local computer, select the Create local share for temporary files option and define the pathname of the shared file on the local computer.

     Note: When you specify this option, the SQL database looks for the shared file locally on its own server under the specified pathname.

   • When the SQL Server is located on a remote computer, select the Use Remote Share directory option and define the full network address of the shared file, including the hostname of the target computer.
4. Specify values for the following fields to define the file structure of the CA GovernanceMinder databases:

   Field Delimiter

   Specifies the character that separates field values in the shared folder.

   Line Delimiter

   Specifies the end-of-line character in the shared folder.

   Note: The characters you specify cannot appear in the data content of the folder. When these characters appear in data fields, the file is parsed incorrectly and bulk insert fails. Similarly, when data strings are longer than their legal length, bulk insert fails.