GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Importing dumps into Sql Server  XML
Forum Index -> General
Author Message
mitja.gti



Joined: 18/12/2011 11:44:15
Messages: 2
Location: Slovenia
Offline

First of all i'd like to give my respect to the people behind GeoNames for this excellent source.

As many before i had the same problem with uploading dumps into Sql Server database.
So 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

application is available here: http://geonames.mitjagti.com
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.
[Thumb - GeoNames2.png]
 Description screenshot of the application [Disk] Download
 Filesize 57 Kbytes
 Downloaded:  860 time(s)

[Thumb - GeoNames3.png]
 Description screenshot of the application [Disk] Download
 Filesize 41 Kbytes
 Downloaded:  865 time(s)

[WWW]
mitja.gti



Joined: 18/12/2011 11:44:15
Messages: 2
Location: Slovenia
Offline

The previous post is now updated to my new domain. Sorry for inconvenience.
[WWW]
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team