Where to get SQL major cities world database?

Asked By Walter Neff 30 points N/A Posted on - 09/18/2012

I’m currently working on an assignment which involves Education and Job Placement. I was wondering if someone knows any good SQL major cities world database to fetch data for my project. Any kind of suggestion would be appreciated.

• Status: Open
• Question Views: 972
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Gillam Janetj

Go To Solution

Answered By Sierra Adams 10 points N/A #163978

Where to get SQL major cities world database?

Hi Walter,

Hope you are doing good. I have a major cities database with me, which are actually insert statements. I downloaded them from http://mydatamaster.com. These fields are Auto generated ID, City Name, Country Code, District, Language, and population. I can share them with you. Please find the attachment for it.

 

About Sierra Adams

Questions
1

Answers
101

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 10/23/2012
• Question Category: MS SQL Server

Answered By Munguia Roya 0 points N/A #163979

Where to get SQL major cities world database?

Hi Walter,

You can find Major Cities database at World Cities Database Website.

 

It has database listing of all cities in the world With Country Codes & States. There is around 2.3 million cities included in the database.

It has 3 tables, City table, Country Table and State Table.

 

Also you can find instruction on how to load data into MySQL.

About Munguia Roya

Questions
2

Answers
12

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/22/2013
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Gillam Janetj 0 points N/A #163980

Where to get SQL major cities world database?

Hi. Walter Neff,

Well to get such data you have to visit someone who knows SQL or you have the second option of doing it yourself, but before that you have to study a little bit so that you eliminate any future problems in fetching your data.

You just have to install a software from the link I am providing you and can easily operate it with its help file.

I have tested it myself and its all working good. So, I will recommend it to you too.

You had to install GeoDataSource from link data

I hope that this will fix your problem.

Thanks & Regards

Gillam Janetj

 

About Gillam Janetj

Questions
1

Answers
105

Best Answers
42

• Vote Up 0 Vote Down

• Posted on - 02/24/2013
• Question Category: MS SQL Server