Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. FuseIT.SDDMS.Executable /DataExport
    This uses the default connection string named, "SalesforceConnectionString", in the config file
    It will use the value of "DataExportPath" in config file, as the path where the dataExport zip files will be stored.
     e.g execute this command line (note spaces): FuseIT.SDDMS /DataExport
  2. 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 /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 

...

  1. 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 to get the schema info , else it will use the default connection string named, "SalesforceConnectionString", in config file for to get the sameschema info
    It will use the value of "DataExportPath" in config file, as the path where the dataExport zip files are stored.
  2. FuseIT.SDDMS /DatabaseGen /scs:YourSalesforceConnectionStringName /sqlcs:YourSqlConnectionStringName "path"
  3. FuseIT.SDDMS /DatabaseGen /scs:useDataCache /sqlcs:SQLConnectionStringName "path"

...

  1. This uses your custom connection strings with the names in the config file.

...

  1. e.g

...

  1. execute this command line (note spaces) - FuseIT.SDDMS

...

  1. /DatabaseGen /scs:

...

  1. YourSalesforceConnectionStringName /sqlcs:

...

  1. YourSqlConnectionStringName "path"
    where /scs

...

  1. is the required Salesforce connection string

...

  1. prefix,
    /sqlcs

...

  1. is the required SQL Server connection string

...

  1. prefix and
    path

...

  1. is the file directory from where the data export files are

...

  1. saved e.g. c:/Myplace

...

  1. FuseIT.SDDMS /DatabaseGen /scs:useDataCache /sqlcs:YourSQLConnectionStringName "path"
    If you want to use the dataCache stored on the file system (stored while DataExport) write "useDataCache" in place of

...

  1. YourSalesforceConnectionStringName.

...

  1. e.g execute this command line (note spaces) - FuseIT.SDDMS /DatabaseGen /scs:useDataCache /sqlcs:YourSQLConnectionStringName "path"

 

3. Data Export and Database Generation Mode

Choose this mode by specifing "/DataExportAndDatabaseGen" as the first argument.
Use  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"

...