How to install the World Cities database on SQL Server?

If you are having trouble importing the world cities database to your SQL Server, here’s a script that will work with SQL Server:

You will need to update the path "C:\Users\user\Documents\your_worldcities_address.csv" with the location of your worldcities.csv file.  If you continue to have trouble,  please reach out to use at and we can send you a .bak file.