Content Comparison

SDDMS is a single application (FuseIT SDDMS Commands:
There are three ways to use the FuseIT.SDDMS.Executable.SDDMS) that has three modes of operation that can be triggered by command line arguments or settings in the 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

The following ways can be used 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 :

1. FuseIT.SDDMS /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 /DataExport /scs:

...

1. YourSalesforceConnectionStringName "path"
   

...

1. This uses your custom connection string with the name

...

1. in the config file
   e.g execute this command line (note spaces) - FuseIT.SDDMS /DataExport /scs:YourSalesforceConnectionStringName "path"
   

...

1. where /scs is the required Salesforce connection prefix and
   path is the file directory where the data export files should be

...

1. saved e.g. c:/Myplace 

...

2. Database Generation Mode:-

...

2. Database Generation Mode

Choose this mode by specifying "/DatabaseGen" as the first argument. To use this mode you must specify SQL connection string in the config file.

The following ways can be used to reference the connection string:

1. FuseIT.SDDMS /DatabaseGen
   This uses the default connection string named, "SqlAdminConnectionString", in the config file to connect to SQL Server. 
   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
2. FuseIT.SDDMS /DatabaseGen /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 /sqlcs:YourSqlConnectionStringName "path"
   where /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

3. Data Export and Database Generation Mode

Choose this mode by specifying "/DataExportAndDatabaseGen" as the first argument. Use Salesforce and SQL Server connection String name and ensure your connection string has your connection strings have been added to the config file.
If you donot want to specify

The following ways can be used to reference 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:/MyplaceNote:- 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"

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.

 :

1. 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
2. FuseIT.SDDMS /DataExportAndDatabaseGen /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 /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

4. Web Application Generation Mode

Choose this mode by specifying "/WebAppGen" as the first argument.

The following ways can be used to reference the connection string:

1. FuseIT.SDDMS /WebAppGen
   This uses the default connection string named, "SqlAdminConnectionString", in the config file to connect to SQL Server.
   e.g execute this command line (note spaces) - FuseIT.SDDMS /WebAppGen
2. FuseIT.SDDMS /WebAppGen /sqlcs:YourSqlConnectionStringName
   This uses your custom connection string with the name in the config file
   e.g execute this command line (note spaces) - /WebAppGen /sqlcs:YourSqlConnectionStringName
   where /sqlcs is the required Salesforce connection prefix

Note:- The values of "appEdmFolder", "modelName" and "webApplicationProject" from the config file nested in appSettings section are required for this mode. 

5. Database Generation and Web Application Generation Mode

Choose this mode by specifying "/DataBaseGenAndWebAppGen" as the first argument.

The following ways can be used to reference the connection string:

1. FuseIT.SDDMS /DataBaseGenAndWebAppGen
   This uses the default connection string named, "SqlAdminConnectionString", in the config file.
   e.g execute this command line (note spaces) - FuseIT.SDDMS /DataBaseGenAndWebAppGen
2. FuseIT.SDDMS /DataBaseGenAndWebAppGen /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 /DataBaseGenAndWebAppGen /sqlcs:YourSqlConnectionStringName "path"
   where /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

6. Data Export, Database Generation and Web Application Generation Mode

Choose this mode by specifying "/CompleteGen" as the first argument. 

The following ways can be used to reference the connection string:

1. FuseIT.SDDMS /CompleteGen
   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 /CompleteGen
2. FuseIT.SDDMS /CompleteGen  /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 /CompleteGen /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