iran-cities icon indicating copy to clipboard operation
iran-cities copied to clipboard

SQL Server Scripts

Open inexuscore opened this issue 3 years ago • 1 comments

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 avatar Oct 29 '21 19:10 inexuscore

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.

inexuscore avatar Oct 29 '21 22:10 inexuscore