Changes for page migrate to managed instance
Last modified by Rudi Marais on 2024/03/28 18:51
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -28,10 +28,15 @@ 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 31 + 32 + 31 31 ))) 34 +* ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT 35 + 32 32 33 -(% class="wikigeneratedid" id="H" %) 34 - {{code language="sql"}}-- index 37 + 38 +{{code language="sql"}} 39 +-- 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' ... ... @@ -81,7 +81,8 @@ 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}} 89 +--and temporal_type in (0,2); 90 +{{/code}} 85 85 86 86 87 87 * disable anti-virus real time scan