Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:command-line:sqlways-ini:ddl-section [May 29, 2018, 11:28:37 AM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:ddl-section [July 12, 2018, 01:42:32 PM] (current)
alexandr.kirpichny
Line 54: Line 54:
 | **SCHEMA_TO_DATABASE** | This option controls schema names conversion for all specified objects for the migration process. If this option is set to "Yes", converted objects will be created under the database with the same name as the source schema has. In that case, the schema name will be obtained from OUTSCHEMA option. If it is set to "No" - the source database structure will be saved. \\ Possible values - Yes, No. \\ Default value - No. | | **SCHEMA_TO_DATABASE** | This option controls schema names conversion for all specified objects for the migration process. If this option is set to "Yes", converted objects will be created under the database with the same name as the source schema has. In that case, the schema name will be obtained from OUTSCHEMA option. If it is set to "No" - the source database structure will be saved. \\ Possible values - Yes, No. \\ Default value - No. |
 | **PARTITION_TABLESPACE** | This option controls whether source partition table tablespaces should be converted or no. In case when the option is set into "Yes", source tablespaces for table partitions will be included in migration solution and target definitions of table partitions will contain tablespaces equal to source tablespaces. If the option = "No", tablespaces for table partitions will be ignored. \\ Possible values - Yes, No. \\ Default value - No. | | **PARTITION_TABLESPACE** | This option controls whether source partition table tablespaces should be converted or no. In case when the option is set into "Yes", source tablespaces for table partitions will be included in migration solution and target definitions of table partitions will contain tablespaces equal to source tablespaces. If the option = "No", tablespaces for table partitions will be ignored. \\ Possible values - Yes, No. \\ Default value - No. |
 +| **REMOVE_VAR_PREFIX** | This option controls the way the source variable prefix like "@" from MS SQL Server, Sybase ASE databases will be replaced in other target databases. In case when the option is set into "Yes", SQLWays will just remove the variable prefix and variable name will be without any additional prefixes. If the option = "No", SQLWays will remove source prefix with the prefix defined in the VAR_PREFIX option. Default prefix that will be used is "v_". User can specify its own prefix that will be used in conversion. \\ Possible values - Yes, No. \\ Default value - Yes. |
 +| **VAR_PREFIX** | This option defines what variable prefix will be used in variables when migrating from such databases like MS SQL Server and Sybase ASE. In this option user can specify its own prefix. \\ Default value - "v_". |
  
 **Example**: **Example**:
sqlways/command-line/sqlways-ini/ddl-section.txt · Last modified: July 12, 2018, 01:42:32 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement