dnnsoftware / Dnn.Platform

DNN (formerly DotNetNuke) is the leading open source web content management platform (CMS) in the Microsoft ecosystem.
https://dnncommunity.org/
MIT License
1.01k stars 745 forks source link

Fixes to sql script and new rollup scripts for version 10 #6038

Open donker opened 1 month ago

donker commented 1 month ago

This PR adds a few missing objectQualifiers from the v10 SQL script and replaces the old 8.0.4 rollup scripts with a new one for v10.

Methodology for creating the rollup scripts

  1. A new/empty DB was created
  2. All SqlDataProvider SQL scripts (i.e. not the membership provider scripts) that the current installation process runs were run using a unique schema (not dbo.) and objectqualifier (not empty)
  3. In SSMS a schema was generated by selecting all tables, views, procedures and functions (i.e. none of the security objects)
  4. Similarly a data script was created.
  5. The data script was parsed and changed to conform to the way DNN runs scripts (remove GO statements within IDENTITY_INSERT blocks).
  6. With search and replace all databaseOwners and objectQualifiers were put back in place.

Note with item 2: DNN runs "Schema", then "Data" and then all scripts higher than 8.0.4 (starting thus with 08.00.04.01). This process was mimicked using a console app to isolate the exact process.

Note this will probably resolve issue #6028

mitchelsellers commented 1 month ago

@donker This looks awesome, I'll test the build results in Azure in the next few days, very curious to see how much this helps install

valadas commented 1 week ago

/azp run

azure-pipelines[bot] commented 1 week ago
Azure Pipelines successfully started running 1 pipeline(s).