Configuring the insert scripts
Eight provided batch files load data files into the database.
In the above directory, you must edit bcp_load_data_files8x.bat
and set the
following variables if needed:
set BULKDIR=C:\Discover\DataExtractor\DataFiles
set SCRIPTDIR=C:\Discover\DataExtractor\Scripts
set DBSERVER=localhost
set DATABASE=TLWEB.dbo
- Variable
- Description
BULKDIR
- The directory on the local server where the generated data files are outputted.
SCRIPTDIR
- The directory where the scripts are located. If the script files
were not moved, this value should be set to the
DataExtractor\Scripts
folder inside the Discover installation directory. DBSERVER
- The host name of the server where the database is stored.
DATABASE
- The name of the database.
Configuring load scripts to use SQL authentication
To use SQL authentication with the BCP load scripts, you must
set the BCPOPTIONS
variable for several script files.
For example, if the set BCPOPTIONS
declaration
is the following in your script files:
set BCPOPTIONS=-F 2 -b 250000 -m 50 -a 32000 -T
It must be changed to the following:
set BCPOPTIONS=-F 2 -b 250000 -m 50 -a 32000 -U login_id -P password
Where:
- Parameter
- Description
-U login_id
- Login ID used to connect to SQL Server. Note: When the bcp utility is connecting to SQL Server with a trusted connection using integrated security, use the
-T
option (trusted connection) instead of the user name and password combination. -P password
- Password for the login ID.
- If this option is not used, the bcp command prompts for a password.
- If this option is used at the end of the command prompt without a password, bcp uses the default password (NULL).
In the <Discover_install_directory>\dataextractor\scripts
directory, the
following files must be updated with the above command:
bcp_bulkappdate8x.bat
bcp_bulkattribute8x.bat
bcp_bulkcookie8x.bat
bcp_bulkevent8x.bat
bcp_bulkhit8x.bat
bcp_bulksesn8x.bat
bcp_bulkurlfield8x.bat