Tag: SQL Server

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 … Continue reading Loading Geonames.org data into SQL Server and SQL Azure or “Why Integers just aren’t the right choice for population fields” →

Entity Data Model generated from SQL 2008 and used with SQL 2005

Ok, this is of course is not a perfect scenario, because ideally my dev and test environments should be identical to my live enviroment. But anyhow, I had some troubles with Entity Framework today. After deployment my WCF services just threw exceptions (have I ever mentioned that I don't like WCF for making everything including … Continue reading Entity Data Model generated from SQL 2008 and used with SQL 2005 →