.sql export with SQL Server Management Studio or sqlcmd. It is a script, not a .bak backup.
These instructions use v5.2.0-export.1, published 3 November 2026. Its core tables contain 250 countries, 5,327 states and 156,169 city records. API data and installed package snapshots can differ. Check the latest release before choosing another version.
Download the release
Run these POSIX-shell commands in a new directory. Downloads are compressed; extract them before opening or importing.Import into a new database
Create a new, empty database before importing. The example uses Windows integrated authentication (-E); select authentication appropriate to your installation.
csc_world, open the extracted script in a query window connected to that database, and execute it. The release creates a schema named world inside the selected database. Its table names are world.countries, world.states and world.cities.
Verify the import
Query the hierarchy
Troubleshooting
- An invalid-object error can mean you omitted the
world.schema prefix. - Use the SQL Server export; MySQL and PostgreSQL dumps use different syntax.
- Back up existing databases before replacing data. Restore failed imports into a new database after investigating the error.