DuendeSoftware / Support

Support for Duende Software products
20 stars 0 forks source link

SQL Server script to update from 6.3 to 7.0 #1299

Closed daver77 closed 3 weeks ago

daver77 commented 4 weeks ago

Hi, our company uses Redgate SQL Change Automation for database source control, we don't use EF migrations. Currently I need to update our IdServer from 6.3 to 7.0, previously I have used the Quickstarts to seed a new database then use a SQL data conmpare tool to generate a migration script but the quickstarts seem to be using SqlLite now.

Is there a SQL Server script anywhere to make that easier for me?

AndersAbel commented 4 weeks ago

We do script out fresh database creation for SQL Server from the EF Migrations tooling at https://github.com/DuendeSoftware/IdentityServer/tree/main/migrations/IdentityServerDb/Migrations To get the right script for each version, please check the git tag.

daver77 commented 4 weeks ago

Perfect, thank you!

RolandGuijt commented 3 weeks ago

@daver77 Closing the issue because it seems resolved for you. Feel free to reopen if anything else comes up.