Summary

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

Details

Page properties

Content

...	...	@@ -27,7 +27,6 @@
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	31	)))
32	32
33	33	(% class="wikigeneratedid" id="H" %)
...	...	@@ -34,30 +34,25 @@
34	34	{{code language="sql"}}-- export
35	35	select export = concat('bcp ', DB_NAME(), '.',
36	36	SCHEMA_NAME(schema_id), '.', name,
37		- ' out "$path\data\', SCHEMA_NAME(schema_id), '_', name, '.bcp" ',
38		- ' -e "$path\export_log\', SCHEMA_NAME(schema_id), '_', name, '.log" ',
39		- ' -S "', '$server','"',
40		- ' -N -U "$username" -P "$password"',
41		- ' | Out-Null')
	36	+ ' out $(path)', SCHEMA_NAME(schema_id), '_', name, '.bcp ',
	37	+ ' -S"', @@servername,'"',
	38	+ ' -N -U"$(username)" -P"$(password)"')
42	42	from sys.tables
43	43	where type = 'U'
44	44	and is_ms_shipped = 0
45		---and temporal_type in (0,2);
	42	+and temporal_type in (0,2);
46	46
47		-
48	48	-- import
49		-select import = concat('bcp "', '$target_db', '.',
	45	+select import = concat('bcp ', DB_NAME(), '.',
50	50	SCHEMA_NAME(schema_id), '.', name,
51		- '" in "$path\data\', SCHEMA_NAME(schema_id), '_', name, '.bcp" ',
52		- ' -e "$path\import_log\', SCHEMA_NAME(schema_id), '_', name, '.log" ',
53		- ' -S "', '$target_server','"',
54		- ' -N -U "$target_username" -P "$target_password"',
55		- ' -b 1000 -E -k -N -q',
56		- ' | Out-Null')
	47	+ ' in $(path)', SCHEMA_NAME(schema_id), '_', name, '.bcp ',
	48	+ ' -S"$(target_server)','"',
	49	+ ' -n -U"$(target_username)" -P"$(target_password)"')
57	57	from sys.tables
58	58	where type = 'U'
59	59	and is_ms_shipped = 0
60		---and temporal_type in (0,2);{{/code}}
	53	+and temporal_type in (0,2);
	54	+{{/code}}
61	61
62	62
63	63	* disable anti-virus real time scan