Page 1 of 1

SQL Server Database

PostPosted: Fri Jul 21, 2006 7:21 pm
by StrangerInBeijing
I am new here...so, HI!

I allready got another database before which gives me the country of an ip, but i also would like cities (Most our visits are from inside China, so country alone does not help)
So I downloaded hostip_current.sql.gz (hostip_current.sql) but from this is a mysql script, which I dont know one little bit.

Is there any way I can convert this script and open in MS Query Analyzer, and run it?

Thanks

PostPosted: Sat Jul 22, 2006 7:21 am
by robocoder
Take a look at the .csv files, mirrored at:

http://ftp.wayne.edu/hostip.info/csv/

It's a simple format that you can easily process (with a script) or load into a spreadsheet for further manipulation.

PostPosted: Sat Jul 22, 2006 10:10 pm
by StrangerInBeijing
Thanks a lot mate

Mind to give me the column names?

Will import into my database on monday

thanks again