FastWrappers-TSQL/xp_RunFastTransfer_secure.sql at master · aetperf/FastWrappers-TSQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
/*
Sample usage
-- use SELECT [dbo].[EncryptString]('<YourPassWordToEncrypt>') to get the encrypted password

EXEC dbo.xp_RunFastTransfer_secure
	@fastTransferDir = 'D:\FastTransfer\',
    @sourceConnectionType = 'mssql',
	@sourceServer = 'localhost',
	@sourceUser = 'FastUser',
	@sourcePasswordSecure = 'wi1/VHz9s+fp45186iLYYQ==',
	@sourceDatabase = 'tpch_test',
	@sourceSchema = 'dbo',
	@sourceTable = 'orders',
	@targetConnectionType = 'msbulk',
	@targetServer = 'localhost\SS2025',
	@targetUser = 'FastUser',
	@targetPasswordSecure = 'wi1/VHz9s+fp45186iLYYQ==',
	@targetDatabase = 'tpch_test',
	@targetSchema = 'dbo',
	@targetTable = 'orders_4_no_index',
	@loadmode = 'Truncate',
	@batchSize = 130000,
	@method = 'RangeId',
	@distributeKeyColumn = 'o_orderkey',
	@degree = 12,
	@mapmethod = 'Name',
	@runId = 'test_MSSQL_to_MSSQL_P12_RangeId',
	@debug=1,
	@loglevel='debug'
*/

CREATE PROCEDURE [dbo].[xp_RunFastTransfer_secure]
	@fastTransferDir [nvarchar](max),
	@sourceConnectionType [nvarchar](30),
	@sourceConnectStringSecure [nvarchar](4000) = NULL,
	@sourceServer [nvarchar](255),
	@sourceDSN [nvarchar](255) = NULL,
	@sourceProvider [nvarchar](1000) = NULL,
	@isSourceTrusted [bit] = 0,
	@sourceUser [nvarchar](1000) = NULL,
	@sourcePasswordSecure [nvarchar](255) = NULL,
	@sourceDatabase [nvarchar](1000),
	@fileInput [nvarchar](4000) = NULL,
	@query [nvarchar](4000) = NULL,
	@sourceSchema [nvarchar](255) = NULL,
	@sourceTable [nvarchar](255) = NULL,
	@targetConnectionType [nvarchar](30),
	@targetConnectStringSecure [nvarchar](4000) = NULL,
	@targetServer [nvarchar](255),
	@isTargetTrusted [bit] = 0,
	@targetUser [nvarchar](1000) = NULL,
	@targetPasswordSecure [nvarchar](255) = NULL,
	@targetDatabase [nvarchar](255),
	@targetSchema [nvarchar](255),
	@targetTable [nvarchar](255),
	@loadMode [nvarchar](50),
	@batchSize [int] = 1048576,
	@method [nvarchar](50) = 'None',
	@distributeKeyColumn [nvarchar](255) = NULL,
	@degree [int] = 4,
	@mapmethod [nvarchar](50) = 'Position',
	@runId [nvarchar](255) = NULL,
	@settingsFile [nvarchar](4000) = NULL,
	@debug [bit] = 0,
	@license nvarchar(4000) = NULL,
	@loglevel nvarchar(50) = 'information'
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [FastWrappers_TSQL].[FastWrapper.FastTransferCLR].[RunFastTransfer_Secure]
GO