...
- FuseIT.SDDMS /DatabaseGen
This uses the default connection string named, "SqlAdminConnectionString", in the config file to connect to SQL Server.
If "useDataCache" is set to true in config file, it will use the dataCache file, else it will use the default connection string named, "SalesforceConnectionString", in config file to get the schema info.
It will use the value of "DataExportPath" in config file, as the path where the dataExport zip files are stored.
e.g execute this command line (note spaces) - FuseIT.SDDMS /DatabaseGen - FuseIT.SDDMS /DatabaseGen /scs:YourSalesforceConnectionStringName /sqlcs:YourSqlConnectionStringName "path"
This uses your custom connection strings with the names in the config file.
e.g execute this command line (note spaces) - FuseIT.SDDMS /DatabaseGen /scs:YourSalesforceConnectionStringName /sqlcs:YourSqlConnectionStringName "path"
where /scs is the required Salesforce connection string prefix,
/sqlcs is the required SQL Server connection string prefix and
path is the file directory from where the data export files are saved e.g. c:/Myplace - FuseIT.SDDMS /DatabaseGen /scs:useDataCache /sqlcs:YourSQLConnectionStringName YourSqlConnectionStringName "path"
If you want to use the dataCache stored on the file system (stored while DataExport) write "useDataCache" in place of YourSalesforceConnectionStringName.
e.g execute this command line (note spaces) - FuseIT.SDDMS /DatabaseGen /scs:useDataCache /sqlcs:YourSQLConnectionStringName YourSqlConnectionStringName "path"
3. Data Export and Database Generation Mode
...
- FuseIT.SDDMS /DataExportAndDatabaseGen
This uses the default connection strings named, "SalesforceConnectionString" and "SqlAdminConnectionString", in the config file.
It uses the values of all the other required parameters from the config file.
e.g execute this command line (note spaces) - FuseIT.SDDMS /DataExportAndDatabaseGen - FuseIT.SDDMS /DataExportAndDatabaseGen /scs:SalesforceConnectionStringName YourSalesforceConnectionStringName /sqlcs:SQLConnectionStringName YourSqlConnectionStringName "path"
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 /DataExportAndDatabaseGen /scs:SalesforceConnectionStringName /sqlcs:SQLConnectionStringName "path"
...
- This uses your custom connection strings with the names in the config file.
e.g execute this command line (note spaces) - FuseIT.SDDMS /DataExportAndDatabaseGen /scs:YourSalesforceConnectionStringName /sqlcs:YourSqlConnectionStringName "path"
where /scs is the required Salesforce connection string prefix,
/sqlcs is the required SQL Server connection string prefix and
path is the file directory from where the data export files are saved e.g. c:/Myplace
Note:- if you want to 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.
...