free country, city database for sql server [closed]

Question

have anyone used this before, i need free country, city, IP database for sqlserver

Answer 1

I have used http://www.maxmind.com/app/geolitecity . It is a less exact version of their paid database. The free database claims to be "over 99.5% on a country level and 79% on a city level for the US within a 25 mile radius". You can see their accuracy detailed at http://www.maxmind.com/app/geolite_city_accuracy.

The data is presented as a CSV file containing the starting IP block, ending IP block, and the location. It is easy enough to load into sqlserver.

APIs in C, C#, PHP, Java, Perl and the free version, GeoLite, has an IPv6 version in addition to the downloadable CSV Format.

Answer 2

ipinfodb provide free geolocation data for MySQL. With a simple database translator, you can put it into different database, since the table structure is simple. They also provide data in CSV format, that will be easier to imported to different database engine.

The data is based on free version of MaxMind, and it's updated every month. They also provide free API, if you don't want to store the data in your server. The accuracy is decent and enough for normal website usage.