January 2009 - Posts

Loading GeoNames Data Into SQL Server 2008 (the PowerShell, bcp way...)
In the first installment on this topic, I used a commercial text editor, EditPad Pro , to perform the Unicode file conversion and SQL Server BULK INSERT to load the data. In this installment, I'm going to change to workflow a bit to use of Microsoft's Read More...
Loading GeoNames Data Into SQL Server 2008 (yet another way...)
In his post last year, Integrating Virtual Earth and GeoNames , Johannes described how to load the GeoNames database into SQL Server using the "Import Data" Wizard in SQL Server Management Studio. In his scenario, Johannes did not need to take Read More...

Search

This Blog

Syndication

Page view tracker