Summary

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

Details

Page properties

Content

...	...	@@ -1,15 +1,25 @@
1		-* compressed file
2		-* contains ddl and dml data
3		-* doesnt support encrypted objects
4		-* cant have any stored procs with string that contain $( character sequence reserved sequence
5		-** break up sequence ie 'test$(test' become 'test$' + '(test'
6		-* [[https:~~/~~/learn.microsoft.com/en-us/azure/azure-sql/database/database-import>>https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import]]
	1	+
	2	+
7	7	* sqlpackage
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 (anti virus)
12	12
	8	+
	9	+1. scale db to accetable performance ie dtus 500
	10	+1. turn off real time scan (anti virus)
	11	+1. run bcp extract scripts [everest & docs parallel]
	12	+11. extract run from smallest to largest table
	13	+1. run schema extracts [not in parallel!]
	14	+1. create db
	15	+1. create schema
	16	+11. prep scripts first
	17	+11. document references
	18	+11. make sure ddl audit triggers are disabled
	19	+1. run imports [parallel]
	20	+11. imports runs from smallest to largest table
	21	+
	22	+
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
15	15	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
...	...	@@ -28,10 +28,14 @@
28	28
29	29	* C:\Users\alliancetest\.mssqlscripter
30	30	* mssql-scripter -S "kula.database.windows.net" -d Everest_Test -U ebsadmin -P xxx -r -f E:\temp\khula_test.sql ~-~-display-progress ~-~-enable-toolsservice-logging
	41	+
	42	+
31	31	)))
	44	+* ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
	45	+
32	32
33		-(% class="wikigeneratedid" id="H" %)
34		- {{code language="sql"}}-- index
	47	+{{code language="sql"}}
	48	+-- index
35	35	select concat('echo ''',SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.bcp ',SCHEMA_NAME(schema_id), '.', name , ''' >> test.log')
36	36	from sys.tables
37	37	where type = 'U'
...	...	@@ -41,12 +41,12 @@
41	41
42	42	-- export
43	43
44		-select '$path = "E:\temp\test"'
45		-select '$server = "server.name"'
46		-select '$username = "user.name"'
47		-select '$password = "pass.word"'
48		-select 'New-Item -ItemType Directory -Force -Path "$path\export_log"'
49		-select 'New-Item -ItemType Directory -Force -Path "$path\data"'
	58	+select '$path = "E:\temp\test\everest_test"' cmd union
	59	+select '$server = "mytest.database.windows.net"' union
	60	+select '$username = "sa"' union
	61	+select '$password = "123456"' union
	62	+select 'New-Item -ItemType Directory -Force -Path "$path\export_log"' union
	63	+select 'New-Item -ItemType Directory -Force -Path "$path\data"'
50	50
51	51	select export = concat('bcp "', DB_NAME(), '.',
52	52	SCHEMA_NAME(schema_id), '.', replace(name,'$','`$'),
...	...	@@ -62,12 +62,12 @@
62	62
63	63	-- import
64	64
65		-
66		-select '$path = "E:\temp\test"'
67		-select '$target_server = "server.name"'
68		-select '$target_username = "user.name"'
69		-select '$target_password = "pass.word"'
70		-select 'New-Item -ItemType Directory -Force -Path "$path\import_log"'
	79	+select '$path = "E:\temp\test\everest_test"' cmd union
	80	+select '$target_server = "sqlmi-ebs-prod.public.2a5fe6cde9a7.database.windows.net,3342"' union
	81	+select '$target_db = "TST_Staging_Everest"' union
	82	+select '$target_username = "import_test"' union
	83	+select '$target_password = ''123456''' union
	84	+select 'New-Item -ItemType Directory -Force -Path "$path\import_log"' union
71	71	select 'New-Item -ItemType Directory -Force -Path "$path\data"'
72	72
73	73	select import = concat('bcp "', '$target_db', '.',
...	...	@@ -81,9 +81,11 @@
81	81	from sys.tables
82	82	where type = 'U'
83	83	and is_ms_shipped = 0
84		---and temporal_type in (0,2);{{/code}}
	98	+--and temporal_type in (0,2);
85	85
	100	+{{/code}}
86	86
	102	+
87	87	* disable anti-virus real time scan
88	88	*
89	89