SDDMS is a single application (FuseIT SDDMS Commands:
There are three ways to use the FuseIT.SDDMS.Executable.SDDMS.Executable) that has three modes of operation that can be trigger by command line arguments or settings in the app.config file.
1. Data Export Mode
...
Choose this mode by specifing specifying "/DataExport" as the first argument.
Use You need to use a Salesforce connection String string name and ensure your a connection string has been added to the config file.If you do not want to specify
There are two ways to reference the connection string name only specify the mode:
Three parameters are required when connecting with a connection string
e.g :
- FuseIT.SDDMS.Executable /DataExport
This uses the default connection string named, "SalesforceConnectionString", in the config file
e.g execute this command line (note spaces): FuseIT.SDDMS.Executable /DataExport - FuseIT.SDDMS.Executable /DataExport /scs:
...
- YourSalesforceConnectionStringName "path"
...
- This uses your custom connection string with the name
...
- in the config file
e.g execute this command line (note spaces)
...
- - FuseIT.SDDMS.Executable /DataExport /scs:YourSalesforceConnectionStringName "path"
where /scs is the required Salesforce connection prefix and
path is the file directory where the data export files should be
...
- saved e.g. c:/Myplace
Note: - If you want to pull schema information then set "pullSchemaInfo" to true in config file. The schema information will be saved with the name 'dataCache' on your file system at the path specified above.
2. Database Generation Mode
...
Choose this mode by specifing "/DatabaseGen" as the first argument.
Use SQL Server connection String name and ensure your connection string has been added to the config file.
If you donot want to specify the connection string name only specify the mode:
Four parameters are required when connecting with a connection string
e.g FuseIT.SDDMS.Executable /DatabaseGen /scs:SalesforceConnectionStringName /sqlcs:SQLConnectionStringName "path"
/scs: Salesforce connection string name (config file)
/sqlcs: SQL Server connection string name (config file)
path: File directory where the data export files are saved
e.g c:/Myplace
Note:- If you want to use the dataCache stored on the file system (stored while DataExport) write "useDataCache" in place of SalesforceConnectionStringName.
i.e. /scs:useDataCache
3. Data Export and Database Generation Mode
...
Choose this mode by specifing "/DataExportAndDatabaseGen" as the first argument.
Use Salesforce and SQL Server connection String name and ensure your connection strings have been added to the config file
If you do not want to specify the connection string name only specify the mode:
Four parameters are required when connecting with a connection strings
e.g FuseIT.SDDMS.Executable /DataExportAndDatabaseGen /scs:SalesforceConnectionStringName /sqlcs:SQLConnectionStringName "path"
...