Last Updated: 1/29/07 5:24PM 1. Place unzip.exe in your PATH (ie. C:\windows) 2. Read the comments in the SQL Script and if you find them acceptable, run the SQL script 3. Read the comments on the VBS file and if you find them acceptable, run the VBS file - Running the script will take about 2-20 minutes - Make sure you run this script on a machine that has bcp installed and in its PATH (like unzip) - If you make any changes to the db name or run this script on a remote machine, ensure strSQLServer and strDBName match your environment - IMPORTANT FOR SCHEDULED IMPORTS: Run this file at least once at the console. You may be prompted to answer Yes to "Do you wish to run this file?" for both the VBS and unzip.exe. Uncheck the box "Always ask when opening this file" and then click "Run" 4. Open up SQL Query Analyzer and have some fun. Read the comments in SQL Server for usage info. 5. Schedule a task to run the vbs script once a month (I'd suggest on the second or third of each month) - Maxmind only updates this file once or twice a month. No need to run this script daily. 5. Thanks a ton, Maxmind! TODO: 1. Add more error handling - Notify via email if the import wasn't successful - Other stuff 2. Further optimize database or procedures/functions