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 [October 26, 2018, 11:57:04 AM]
darya.prikhodkina [Sqlways.ini File - Section [DDL]]
sqlways:command-line:sqlways-ini:ddl-section [November 30, 2018, 02:58:08 PM] (current)
alexandr.kirpichny [Sqlways.ini File - Section [DDL]]
Line 83: Line 83:
 | **EXPORT_CONSTRAINTS_FOR_QUERIES** | This option controls whether the constraints should be converted when doing conversion using the queries. \\ Possible values - "Yes", "No". \\ Default value - "Yes". | | **EXPORT_CONSTRAINTS_FOR_QUERIES** | This option controls whether the constraints should be converted when doing conversion using the queries. \\ Possible values - "Yes", "No". \\ Default value - "Yes". |
 | **CONVERT_MM_TAB** | This option defines how multi-member tables will be converted from DB2 AS 400 into Microsoft SQL Server database. If this option is set to "SINGLE" - our tool will try to extract date from all the members created on this table in DB2 database and load all the extracted data into one table in MSSQL. In that case table in MSSQL will have the same name as original table in DB2. If this option is set to "MULTIPLE" - our tool will extract information about the table and data from each member and will create separate tables in MSSQL for each member with the same structure as the original table. It means that in the target database we will have multiple tables with data and the same name as corresponding member. \\ Possible values - "SINGLE" or "MULTIPLE". \\ Default value - "SINGLE". | | **CONVERT_MM_TAB** | This option defines how multi-member tables will be converted from DB2 AS 400 into Microsoft SQL Server database. If this option is set to "SINGLE" - our tool will try to extract date from all the members created on this table in DB2 database and load all the extracted data into one table in MSSQL. In that case table in MSSQL will have the same name as original table in DB2. If this option is set to "MULTIPLE" - our tool will extract information about the table and data from each member and will create separate tables in MSSQL for each member with the same structure as the original table. It means that in the target database we will have multiple tables with data and the same name as corresponding member. \\ Possible values - "SINGLE" or "MULTIPLE". \\ Default value - "SINGLE". |
 +| **ORACLE_PKG_TO_FN** | This option allows to change package conversion structure logic from Oracle to Greenplum migration direction. By default Oracle packages are converted to sets of Greenplum functions corresponding to source package routines. Package global variables are converted using temporary tables. If the option is set to 'Yes', Oracle package will be converted into one function which takes 1 parameter to pass package routine name and branches package routines logic via IF...ELSE structures.Package global variables in that case will be converted to function local variables.\\ Possible values - "Yes", "No". \\ Default value - "Yes". |
  
  
sqlways/command-line/sqlways-ini/ddl-section.txt · Last modified: November 30, 2018, 02:58:08 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement