Changes for page migrate to managed instance
Last modified by Rudi Marais on 2024/03/28 18:51
Change comment:
Updated parent field.
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Parent
-
... ... @@ -1,1 +1,1 @@ 1 -technical-documentation.analysis.sql.WebHome 1 +xwiki:technical-documentation.analysis.sql.WebHome - Content
-
... ... @@ -8,7 +8,6 @@ 8 8 ** [[https:~~/~~/download.microsoft.com/download/7/c/8/7c877288-a0d9-4d22-b1dc-2086e262d82f/x64/DacFramework.msi>>https://download.microsoft.com/download/7/c/8/7c877288-a0d9-4d22-b1dc-2086e262d82f/x64/DacFramework.msi]] 9 9 ** [[https:~~/~~/learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download>>https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download]] 10 10 ** C:\Program Files\Microsoft SQL Server\160\DAC\bin 11 -* turn off real time scan 12 12 13 13 1. run extract with [[sql-script-db.ps1>>doc:technical-documentation.Source Control.migration.sql.sql-db-export.WebHome]] with validate set to true and raw objects set to true, only need tbl-triggers, functions and sp 14 14 11. reason for this is to identify any procedure/triggers/functions that dont compile ... ... @@ -22,7 +22,7 @@ 22 22 1. run dacpac publish to managed instance 23 23 1. 24 24 25 -= =24 += = 26 26 27 27 28 28