Last modified by Rudi Marais on 2024/03/28 18:51
<
From version < 8.12 >
edited by Rudi Marais
on 2024/03/07 15:27
To version < 8.4 >
edited by Rudi Marais
on 2024/03/07 12:52
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -27,72 +27,36 @@
27 27  [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
28 28  
29 29  * C:\Users\alliancetest\.mssqlscripter
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 -
33 33  )))
34 -* ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
35 -
36 36  
37 -
38 -{{code language="sql"}}
39 --- index
40 -select concat('echo ''',SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.bcp ',SCHEMA_NAME(schema_id), '.', name , ''' >> test.log')
32 +(% class="wikigeneratedid" id="H" %)
33 + {{code language="sql"}}-- export
34 +select export = concat('bcp ', DB_NAME(), '.',
35 + SCHEMA_NAME(schema_id), '.', name,
36 + ' out $(path)', SCHEMA_NAME(schema_id), '_', name, '.bcp ',
37 + ' -S"', @@servername,'"',
38 + ' -N -U"$(username)" -P"$(password)"')
41 41  from sys.tables
42 42  where type = 'U'
43 43  and is_ms_shipped = 0
42 +and temporal_type in (0,2);
44 44  
45 ---and temporal_type in (0,2);
46 -
47 --- export
48 -
49 -select '$path = "E:\temp\test"'
50 -select '$server = "server.name"'
51 -select '$username = "user.name"'
52 -select '$password = "pass.word"'
53 -select 'New-Item -ItemType Directory -Force -Path "$path\export_log"'
54 -select 'New-Item -ItemType Directory -Force -Path "$path\data"'
55 -
56 -select export = concat('bcp "', DB_NAME(), '.',
57 - SCHEMA_NAME(schema_id), '.', replace(name,'$','`$'),
58 - '" out "$path\data\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.bcp" ',
59 - ' -e "$path\export_log\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.log" ',
60 - ' -S "', '$server','"',
61 - ' -N -U "$username" -P "$password"',
62 - ' | Out-Null')
63 -from sys.tables
64 -where type = 'U'
65 -and is_ms_shipped = 0
66 ---and temporal_type in (0,2);
67 -
68 68  -- import
69 -
70 -
71 -select '$path = "E:\temp\test"'
72 -select '$target_server = "server.name"'
73 -select '$target_username = "user.name"'
74 -select '$target_password = "pass.word"'
75 -select 'New-Item -ItemType Directory -Force -Path "$path\import_log"'
76 -select 'New-Item -ItemType Directory -Force -Path "$path\data"'
77 -
78 -select import = concat('bcp "', '$target_db', '.',
79 - SCHEMA_NAME(schema_id), '.', replace(name,'$','`$'),
80 - '" in "$path\data\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)) , '.bcp" ',
81 - ' -e "$path\import_log\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)) , '.log" ',
82 - ' -S "', '$target_server','"',
83 - ' -N -U "$target_username" -P "$target_password"',
84 - ' -b 1000 -E -k -N -q',
85 - ' | Out-Null')
45 +select import = concat('bcp ', DB_NAME(), '.',
46 + SCHEMA_NAME(schema_id), '.', name,
47 + ' in $(path)', SCHEMA_NAME(schema_id), '_', name, '.bcp ',
48 + ' -S"$(target_server)','"',
49 + ' -n -U"$(target_username)" -P"$(target_password)"')
86 86  from sys.tables
87 87  where type = 'U'
88 88  and is_ms_shipped = 0
89 ---and temporal_type in (0,2);
53 +and temporal_type in (0,2);
90 90  {{/code}}
91 91  
92 92  
93 93  * disable anti-virus real time scan
94 -*
95 95  
59 +
96 96  (% class="wikigeneratedid" %)
97 97  placeholder
98 98  
... ... @@ -153,3 +153,5 @@
153 153  * incubator/ebsphere.crm/ebs-devops-devops-sql/calc-signature-bacpac.ps1
154 154  * modify Origin.xml
155 155  ** Checksum attribute for model.xml
120 +
121 +

Applications

Navigation

Need help?

If you need help with XWiki you can contact: