search

ahmadazizi / iran-cities

The most accurate database of city, county, village and province names of Iran.
MIT License
441 stars 77 forks source link

SQL Server Scripts #14

Open inexuscore opened 2 years ago

inexuscore commented 2 years ago

Hello, thank you very much for putting this repository together. Unfortunately, I couldn't use the SQL scripts in MSSQL. I could write a simple console app, read the CSV files and populate a database manually. But it's quite time-consuming and getting the indexes and relationships right is a bit tedious too.

Could you please include the SQL Server scripts too? That would be invaluable in this repository.

Thank you very much.

inexuscore commented 2 years ago

I've done exactly what I mentioned 🧐 I created a SQL Server database manually, wrote a C# console app to read the CSV files, and populated the database. If anyone's interested, I could make a PR and add the MSSQL scripts. Cheers.