Preparing the Batch File

Chapter 8 discussed the dw_regular.sql script to load new data. This script needs to be run daily. Listing 9.1 presents a batch file that should be invoked to run the dw_regular.sql script.

Listing 9.1. DW regular population batch

mysql.exe -udwid uuserid -ppw -D dw <
       c:mysqlscriptsdw_regular.sql

You must call the mysql.exe command with the correct user id and password and specify the database name and the full path to the dw_regular.sql script.