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:

https://www.dropbox.com/scl/fi/lb6mirwd2c9etqon4a5ho/worldcities_sqlserver.sql?rlkey=oak9ilta0rfsqucfzjtcthrmn&st=0t0zxsnb&dl=1

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 support@simplemaps.com and we can send you a .bak file.