Loading D&B Data on Microsoft SQL Server

Microsoft SQL Server installations require you to run SQL scripts. You need the following format files and SQL scripts:

• For loading the Marketing Data file:

  • S_DNB_UPDATE.fmt. A format file to load the data into the tempS_DNB_UPDATE table

  • S_DNB_UPDATE.sql. An SQL script that loads the data into S_DNB_UPDATE table

• For loading the SIC file:

  • S_DNB_SIC.fmt. A format file to load the data into the tempS_DNB_SIC table

  • S_DNB_SIC.sql. An SQL script that loads the data into the S_DNB_SIC table

• For loading the MRC file:

  • S_DNB_MRC.fmt. A format file to load the data into the tempS_DNB_MRC table

  • S_DNB_MRC.sql. An SQL script that loads the data into the S_DNB_MRC table

Note: This procedure assumes that you understand how to run bcp (bulk copy process) or similar data-loading utility. The bcp utility is described in the Microsoft SQL Server documentation.

To load D&B data if you are using Microsoft SQL Server

1. Verify that the column order of your D&B file matches the column requirements in the SQL file before running the loading script.

2. Truncate the appropriate staging tables.

   For more information, see the table that describes D&B Data to Delete and Unload in topic Loading D&B Data.

   To optimize loading performance, drop all indexes on the S_DNB_UPDATE table and re-create them after the scripts have completed by using Siebel utilities ddlexp (to back up the indexes before dropping) and ddlimp (to re-create them).

3. Modify the SQL file as appropriate for:

   • The name of your database

   • The D&B filename and directory location

   • The database table owner

   • The user ID and password (with loading privileges) that you are using to load the data

4. Run bcp or another data loading utility.