How to load NAVTEQ data in SQL Server 2005 in 6 easy steps

Working in IT Operations is really fantastic and interesting but you need to update yourself on daily basis. Your innovative skills nourishes everyday and you will feel that there are endless possibilities to work with IT equipments. I know this post will not be very much interesting for most of the readers of IT Operationz but few people might find this post very much interesting. Perhaps someone out there would be looking for some comprehensive guide to load data in SQL from NAVTEQ. I know that NAVTEQ provide a guide to prepare and  load the data but that’s a very lengthy guide to extract, prepare and load the data in SQL server 2005 database. It took me two weeks to extract, prepare and load the data into SQL server 2005 database, although the size of the data was huge but the preparation took most of the time. I was given this task again to load the new data from NAVTEQ in SQL server 2005 and I did it just in three days because loading data took more than two days and the complete size of the databases may exceed 900GB (I loaded two databases for complete Q1 for Europe). However I would like to talk about one database over here. How I did this, see the steps given as under:

Step 1: Download the data from NAVTEQ website with high speed (as much as provided by your service provider) Place the data at your hard drive somewhere (For hardware requirements please see the NAVTEQ guide) (one thing for the hard drive please one TB hard drive to save yourself from any inconvenience)

Step 2: Extract all files to the ..MSSQL2005loaderfiles folder (Delete the compressed files after extraction) (Under loaderfiles there are several other folders like admin, rdfcore, etc) (Extract the files to the respective folders)

Read more