FastTransfer-Documentation/fasttransfer_grammar_ebnf.ebnf at main · aetperf/FastTransfer-Documentation · 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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
Syntax ::=
    FastTransferCommand FastTransferOptions

FastTransferCommand ::=
    ( "'.\FastTransfer.exe'" | "'./fasttransfer'" )

FastTransferOptions ::=
    "--sourceconnectiontype" SourceConnectionType
    SourceConnectionParameters
    SourceInfos
    "--targetconnectiontype" TargetConnectionType
    TargetConnectionParameters
    TargetInfos
    (|ParallelParameters)
    (|MappingParameters)
    (|LogParameters)
    (|LicenseParameters)


SourceConnectionType ::=
    ( "clickhouse"
    | "duckdb"
    | "hana"
    | "mssql"
    | "mysql"
    | "nzsql"
    | "odbc"
    | "oledb"
    | "oraodp"
    | "pgcopy"
    | "pgsql"
    | "teradata"
    )

SourceConnectionParameters ::=
    ((
      "--sourceserver"
      ("Host"
       | "Host:Port" | "Host\InstanceName" | "Host:Port/TNSService" )
    (|"--sourceprovider" OLEDBProvider)
      |("--sourcedsn" DSNName)
    )
    ( "--sourcetrusted"  | ( "--sourceuser" "Username" "--sourcepassword" "Password" ))
      "--sourcedatabase" "Database")

  | ( "--sourceconnectstring" ConnectString )


SourceInfos ::=
    (( "--sourceschema" SchemaName "--sourcetable" TableName) | ("--query" Query | "--query" Query "--sourceschema" SchemaName "--sourcetable" TableName)  | ("--fileinput" FilePath | "--fileinput" FilePath "--sourceschema" SchemaName "--sourcetable" TableName))


TargetConnectionType ::=
    ( "clickhousebulk"
    | "duckdb"
    | "hanabulk"
    | "msbulk"
    | "mysqlbulk"
    | "nzbulk"
    | "orabulk"
    | "oradirect"
    | "pgcopy"
    | "teradata"
    )

TargetConnectionParameters ::=
    ((
      "--targetserver"
      ("Host"
       | "Host:Port" | "Host\InstanceName" | "Host:Port/TNSService" )
    )
    ( "--targettrusted"  | ( "--targetuser" "Username" "--targetpassword" "Password" ))
      "--targetdatabase" "Database")

  | ( "--targetconnectstring" ConnectString )

TargetInfos ::=
     "--targetschema" SchemaName
     "--targettable" TableName
	 (|"--loadmode" ("Append" | "Truncate"))
	 (|"--batchsize" "BatchSizeInt")

ParallelParameters ::=
    "--method" ( "None"| ((("Random" | "DataDriven" | "RangeId" | "Ntile" ) "--distributeKeyColumn" "KeyColumn") | "Ctid" | "Rowid"  ) "--degree" Degree)

MappingParameters ::=
 "--mapmethod" ("Position" | "Name")

LogParameters ::=
    (|"--runid" RunId)
    (|"--settingsfile" SettingsFile)
    (|"--loglevel" loglevel)

LicenseParameters ::=
"--license" (licenseFile|licenseUrl)