free country, city database for sql server

Question

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

Solution 1

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.

Solution 2

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.

Solution 3

If you need to find the location of the current user based on their IP address, then you could try the Google Geolocation API, in particular google.loader.ClientLocation.

Check out the Google API docs for more info: http://code.google.com/apis/ajax/documentation/#ClientLocation

Solution 4

You can find the Mysql Database from here too...

https://github.com/baraskar/Worlds-Country-State-and-City-Mysql-Database

Suggestions always welcome...

Solution 5

Not exactly for SQL Server but for MySQL, I suggest, you to checkout this GitHub repository:

https://github.com/turalus/openDB

View more solutions

Comments

[Jason Cohen]

+1 'cause that's right, but in my experience it very often has no idea where you're from. At least it tells you when it doesn't know. Seems to be better IDing residential things than commercial.

[Alessandro De Simone]

they no longer provide the db