Loading Geonames.org data into SQL Server and SQL Azure or “Why Integers just aren’t the right choice for population fields”

For a current project I’ve loaded country and city data from GeoNames and since most of the guides are outdated let me briefly summarize how to get a dump (available hereĀ – works for the “allCountries” file or single countries). Step 1 – the schema The file is tab-delimited and follows the schema described here. The … More Loading Geonames.org data into SQL Server and SQL Azure or “Why Integers just aren’t the right choice for population fields”