Summary

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

Details

Page properties

Content

...	...	@@ -40,17 +40,9 @@
40	40	--and temporal_type in (0,2);
41	41
42	42	-- export
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" ',
	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" ',
54	54	' -e "$path\export_log\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)), '.log" ',
55	55	' -S "', '$server','"',
56	56	' -N -U "$username" -P "$password"',
...	...	@@ -61,15 +61,6 @@
61	61	--and temporal_type in (0,2);
62	62
63	63	-- 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		-
73	73	select import = concat('bcp "', '$target_db', '.',
74	74	SCHEMA_NAME(schema_id), '.', replace(name,'$','`$'),
75	75	'" in "$path\data\', SCHEMA_NAME(schema_id), '_', BASE64_ENCODE (cast(name as varbinary)) , '.bcp" ',
...	...	@@ -81,8 +81,7 @@
81	81	from sys.tables
82	82	where type = 'U'
83	83	and is_ms_shipped = 0
84		---and temporal_type in (0,2);
85		-{{/code}}
	67	+--and temporal_type in (0,2);{{/code}}
86	86
87	87
88	88	* disable anti-virus real time scan