SDDMS is a single application (FuseIT.SDDMS) that has three modes of operation that can be triggered by command line arguments or settings in the config file.
Choose this mode by specifying "/DataExport" as the first argument. You need to use a Salesforce connection string name and ensure a connection string has been added to the config file.
There are two ways to reference the connection string:
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 along with the DataExport zip files at the path specified above.
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 do not 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
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"
Note:- You cannot use data cache in this mode. But, if you want to pull the schema information in DataExport section and use it while generating database, then set 'pullSchemaInfo' and 'useDataCache' to true in config file.