Summary

• Page properties (3 modified, 0 added, 0 removed)

Details

Page properties

Title

...	...	@@ -1,1 +1,1 @@
1		-migrate to managed instance
	1	+bacpac

Parent

...	...	@@ -1,1 +1,1 @@
1		-xwiki:technical-documentation.analysis.sql.WebHome
	1	+Technical Documentation.analysis.sql.WebHome

Content

...	...	@@ -9,7 +9,8 @@
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	11
12		-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
	12	+
	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
13	13	11. reason for this is to identify any procedure/triggers/functions that dont compile
14	14	1. once this is done examine results and fix stored procedures on database so that they can compile, ie add missing columns or modify code to not require them
15	15	11. repeat step 1 and 2 until you get zero objects that can't compile
...	...	@@ -21,7 +21,7 @@
21	21	1. run dacpac publish to managed instance
22	22	1.
23	23
24		-= =
	25	+= =
25	25
26	26
27	27