Summary

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

Details

Page properties

Content

...	...	@@ -40,9 +40,17 @@
40	40	--and temporal_type in (0,2);
41	41
42	42	-- export
43		-select export = concat('bcp ''', DB_NAME(), '.',
44		- SCHEMA_NAME(schema_id), '.', name,
45		- ''' out "$path\data\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.bcp" ',
	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"'
	50	+
	51	+select export = concat('bcp "', DB_NAME(), '.',
	52	+ SCHEMA_NAME(schema_id), '.', replace(name,'$','`$'),
	53	+ '" out "$path\data\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.bcp" ',
46	46	' -e "$path\export_log\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.log" ',
47	47	' -S "', '$server','"',
48	48	' -N -U "$username" -P "$password"',
...	...	@@ -53,6 +53,15 @@
53	53	--and temporal_type in (0,2);
54	54
55	55	-- import
	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"'
	71	+select 'New-Item -ItemType Directory -Force -Path "$path\data"'
	72	+
56	56	select import = concat('bcp "', '$target_db', '.',
57	57	SCHEMA_NAME(schema_id), '.', replace(name,'$','`$'),
58	58	'" in "$path\data\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)) , '.bcp" ',
...	...	@@ -68,6 +68,7 @@
68	68
69	69
70	70	* disable anti-virus real time scan
	88	+*
71	71
72	72	(% class="wikigeneratedid" %)
73	73	placeholder