http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net i wrote a simple application that will handle that for you. *requires minimum ammount of memory (can handle any dump size without OutOfMemoryException) *supports remote insert (dump file doesn't have to be on the same file system as Sql server) *can upload/create only certain fields :arrow: application is available here: http://geonames.mitjagti.com :arrow: more info, comments, bugs etc.: http://blog.mitjagti.com/post/2011/12/18/Import-GeoNames-dump-into-SQL-Server.aspx For now it only supports: geoname table, post codes table, countryInfo table. If i'll see a lot of interests for this application i will add all the rest of the tables and will make sure that it's up to date. Admins/Owners of GeoNames: If there's any problem with using your logo in this application or any other comment about legal rights or any other for that matter, please do tell me. ]]> http://forum.geonames.org/gforum/posts/list/3639.page#11006 http://forum.geonames.org/gforum/posts/list/3639.page#11006 GMT http://forum.geonames.org/gforum/posts/list/3639.page#12082 http://forum.geonames.org/gforum/posts/list/3639.page#12082 GMT