Ispirer Migration Knowledge Base

User Tools

Site Tools

You are here: Ispirer Migration Knowledge Base » Ispirer Migration Knowledge Base » User's Guide » SQLWays Wizard » choose-target-db » Advanced Button

Differences

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

Link to this comparison view

sqlways:users-guide:wizard:choose-target-db:advanced [July 31, 2018, 12:26:07 PM] – [Quoted Identifier] alexandr.kirpichnysqlways:users-guide:wizard:choose-target-db:advanced [May 31, 2023, 05:28:12 PM] (current) – external edit 127.0.0.1
Line 1: Line 1:
 \\ \\
-[[http://www.ispirer.com|Ispirer Home Page]] +[[https://www.ispirer.com|Ispirer Website]] 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] +[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ====== Advanced Button ====== ====== Advanced Button ======
  
Line 11: Line 10:
  
  
-Options on the "Advanced" tab for Oracle as a target database are divided into sections:+Options on the "Advanced" tab for Oracle as a target database are divided into the following sections:
  
    * **SQL Loader Options**  -  includes options for sqlldr.exe utility    * **SQL Loader Options**  -  includes options for sqlldr.exe utility
Line 23: Line 22:
 === Rows === === Rows ===
  
-Identifies the number of rows you want to read from the datafile before a data save for Direct path loads. The default is to read all the rows and save data at the end of the load.+Identifies the number of rows you want to read from the datafile before data save for Direct path loads. The default is to read all the rows and to save data at the end of the load.
  
  
Line 38: Line 37:
 === Max Errors ===  === Max Errors === 
  
-Defines maximum number of errors that are allowable after which the loader process exits. When this option is empty will be used default value that is equal to 50.+Defines maximum number of allowed errors, after which the loader process will exit. When this option is empty, the default value equal to 50 will be applied.
  
  
Line 57: Line 56:
 === Rows === === Rows ===
  
-Identifies the number of rows you want to read from the datafile before a data save for Direct path loads. The default is to read all the rows and save data at the end of the load.+Identifies the number of rows you want to read from the datafile before data save for Direct path loads. The default is to read all the rows and to save data at the end of the load.
  
  
 === Character Set === === Character Set ===
  
-This option defines the encoding that will be used to store the extracted data in the files in export folder and then load this data into Oracle database.+This option defines the encoding that will be used to store the extracted data in the files in export folder and then will be used to load this data into Oracle database.
  
  
Line 76: Line 75:
 === Unrecoverable === === Unrecoverable ===
  
-If check data load process will be performed in the UNRECOVERABLE mode.+If checked, data load process will be performed in the UNRECOVERABLE mode.
  
  
Line 82: Line 81:
  
 Specifies generating DECODE function in the SQL Loader control file for CHAR NOT NULL columns for fixed-length text file. Possible values - Yes, No. The default value is "No". Specifies generating DECODE function in the SQL Loader control file for CHAR NOT NULL columns for fixed-length text file. Possible values - Yes, No. The default value is "No".
-If you want to load fields that contain only blanks into CHAR NOT NULL columns and the text file has the fixed length format, you have to use DECODE function, because SQL Loader treats blanks as NULLs. Set this option to "Yes" and SQLWays will generate DECODE function to convert NULLs to blanks. +If you want to load the fields that contain only blanks into CHAR NOT NULL columns and the text file has the fixed length format, you have to use DECODE function, because SQL Loader treats blanks as NULLs. Set this option to "Yes" and SQLWays will generate DECODE function to convert NULLs to blanks. 
  
  
Line 89: Line 88:
 === Executable === === Executable ===
  
-The name of the executable module of the Oracle SQL Plus. The default value is sqlplus.exe. +The name of the executable module of Oracle SQL Plus. The default value is sqlplus.exe. 
  
 === Generate The EXIT Command === === Generate The EXIT Command ===
Line 98: Line 97:
 === Use The TO_DATE Function === === Use The TO_DATE Function ===
  
-If checked, the TO_DATE function with the corresponding date format is generated for DATE columns in SQL INSERT statements for SQL Plus. This allows to insert rows that contains DATE columns when the date format differs from the default date format for Oracle database. If unchecked, the TO_DATE function is not generated in SQL INSERT statements. Possible values - Yes, No. The default value is "Yes".+If checked, the TO_DATE function with the corresponding date format is generated for DATE columns in SQL INSERT statements for SQL Plus. This allows to insert rows that contain DATE columns when the date format differs from the default date format for Oracle database. If unchecked, the TO_DATE function is not generated in SQL INSERT statements. Possible values - Yes, No. The default value is "Yes".
  
    
Line 115: Line 114:
 === Use Tablespace Names From Source Database === === Use Tablespace Names From Source Database ===
  
-If checked, will be used tablespace name from source database for tables and indexes.+If checked, tablespace name from source database will be used for tables and indexes.
 ===== Ispirer On The Fly Data Migrator ===== ===== Ispirer On The Fly Data Migrator =====
  
Line 125: Line 124:
 === BIN directory === === BIN directory ===
  
-This text-box allows you to specify the path to the folder containing the //ISOFDM.exe// tool. Usually the path specification is not required as SQLWays automatically searches for the BIN directory. If the text-box is empty, first it searches the PATH variable, then it searches the registry. If it failed to find the path to the //ISOFDM.exe//, no path is added to the command and system may return the error on the command execution.+This text-box allows you to specify the path to the folder containing the //ISOFDM.exe// tool. Usually the path specification is not required as SQLWays automatically searches for the BIN directory. If the text-box is empty, first it searches the PATH variable, then it searches the registry. If it fails to find the path to the //ISOFDM.exe//, no path will be added to the command and system may return the error on the command execution.
  
 === Read Size === === Read Size ===
  
-This text-box allows you to specify the number or rows of data that is selected from source database in one iteration.+This text-box allows you to specify the number or rows of data selected from source database within one iteration.
  
 === Commit Size === === Commit Size ===
Line 137: Line 136:
 === Bulk Size === === Bulk Size ===
  
-This text-box lets you specify how many rows of data will be included into one BULK INSERT command to perform the load of the data into the target database. This allows to enhance the insert speed as it's far faster than initiating an insert of each row of data into table. If BULK INSERT is specified as 0 then insert of data into a target table is performed for each row.+This text-box lets you specify how many rows of data will be included into one BULK INSERT command to perform the load of the data into the target database. This allows to enhance the insert speed as it's far faster than initiating an insert of each row of data into table. If BULK INSERT is specified as 0, insert of data into a target table is performed for each row.
 === Character set === === Character set ===
  
-Specifies how to interpret the data stored in the memory to be loaded to the database. If no character set is not specified then the default target database character set is used. +Specifies how to interpret the data stored in the memory to be loaded to the database. If no character set is specified then the default target database character set is used. 
 You can enter a character set manually: You can enter a character set manually:
  
Line 156: Line 155:
 This option allows to specify whether to perform TRUNCATE TABLE before import of the data into a table. This option allows to specify whether to perform TRUNCATE TABLE before import of the data into a table.
  
-By default the Truncate target tables check-box isn't selected.+By default the Truncate target tables option is unchecked.
 === Disable table triggers === === Disable table triggers ===
  
-This option allows to specify whether to DISABLE ALL TRIGGERS for target table before import of the data.+This option allows to specify whether to DISABLE ALL TRIGGERS for target table before data import.
  
-By default the Disable table triggers check-box is selected.+By default the Disable table triggers check-box is enabled.
  
  
Line 182: Line 181:
 === Use Filegroup Names From Source Database === === Use Filegroup Names From Source Database ===
  
-If checked, will be used filegroup names from source database for tables and indexes.+If checked, filegroup names from source database will be used for tables and indexes.
  
  
Line 197: Line 196:
 === Hint === === Hint ===
  
-This option specifies the hint or hints to be used during a bulk import of data into a table in MSSQL Database. All the possible hints are supported in our toolkit. More information about the hints supported by MSSQL BCP utility you can find here: [[https://docs.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-2017#h|MSSQL Server BCP Hints]]. \\ Possible values: Hints supported by MSSQL Server.+This option specifies the hint or hints to be used during a bulk import of data into a table in MSSQL Database. All the possible hints are supported in our toolkit. More information about the hints supported by MSSQL BCP utility can be found here: [[https://docs.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-2017#h|MSSQL Server BCP Hints]]. \\ Possible values: Hints supported by MSSQL Server.
  
 === Codepage === === Codepage ===
Line 205: Line 204:
 === Quoted Identifier ===  === Quoted Identifier === 
  
-This option defines the way how MSSQL native utilities (sqlcmd.exe and bcp.exe) will treat quoted delimiters and data. If this option is set to “Yes” identifiers should be delimited with double quotes and literals must be delimited with single quotation marks. When this option is set to “No”, then only brackets [] can be used to delimit identifiers and double quotation marks will be used to delimit character strings.+This option defines the way how MSSQL native utilities (sqlcmd.exe and bcp.exe) will treat quoted delimiters and data. If this option is set to “Yes” identifiers should be delimited with double quotes and literals must be delimited with single quotation marks. When this option is set to “No”, only brackets [] can be used to delimit identifiers and double quotation marks will be used to delimit character strings.
  
  
 === Case Sensitive Collation === === Case Sensitive Collation ===
  
-This option check object names case. If this option is set to “Yes”, our tool will check the object names taking into account name case. If two objects have the same names and they are written in the same way, for example 'Tab' and 'Tab', in that case suffix will be added to one of the objects. If there are two objects with the same names, but they are written in different manner, for example 'Tab' and 'TAB', in that case no suffix will be added, as this option is set to “Yes”. +This option checks object names case. If this option is set to “Yes”, our tool will check the object names taking into account name case. If two objects have the same names written in the same way, for example 'Tab' and 'Tab', suffix will be added to one of the objects. If there are two objects with the same names, but they are written in different manner, for example 'Tab' and 'TAB', no suffix will be added, as this option is set to “Yes”. 
  
 === Use Active Directory === === Use Active Directory ===
Line 271: Line 270:
 ====== PostgreSQL ====== ====== PostgreSQL ======
  
-{{:sqlways:users-guide:wizard:choose-target-db:pg_adv.png?300}}+{{:sqlways:users-guide:wizard:choose-target-db:adv_trg_pg_opt.png|}}
  
  
-=== Tablespaces ===+===== Tablespaces =====
  
 In PostgreSQL tables and indexes can be stored in separate tablespaces. In SQLWays you can specify the tablespace for //Tables// or //Indexes// in the target PostgreSQL database, or //Use tablespace names from source database// in the //Tablespaces// section of the //Advnaced// page. In PostgreSQL tables and indexes can be stored in separate tablespaces. In SQLWays you can specify the tablespace for //Tables// or //Indexes// in the target PostgreSQL database, or //Use tablespace names from source database// in the //Tablespaces// section of the //Advnaced// page.
  
-=== Create tables with OIDS ===+===== Create tables with OIDS =====
  
 <html><acronym title="Object IDentifier">OID</acronym></html> column is a system column created for each table. It contains the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. As the default the check-box is checked. This means that all the //CREATE TABLE// statements will be created with the //WITH OIDS// option. <html><acronym title="Object IDentifier">OID</acronym></html> column is a system column created for each table. It contains the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. As the default the check-box is checked. This means that all the //CREATE TABLE// statements will be created with the //WITH OIDS// option.
 +
 +===== SSL Settings =====
 +
 +These options allows to use SSL connection to the target PostgreSQL database.
 + 
 +=== Use SSL Connection ===
 +
 +This checkbox defines whether SSL will be used to connect to the target database. If this option is checked, then client need to provide all the required options in SSL section in order to connect to PostgreSQL using SSL connection.
 +
 +=== SSL Mode === 
 +
 +This option defines the SSL mode. Possible values: allow, disable, prefer, requirer, verify-ca, verify-full.
 +
 +=== Client Certificate ===
 +
 +This option defines path to the Client Certificate on the local machine.
 +
 +=== Client Key ===  
 +
 +This option defines path to the Client Key on the local machine.
 +
 +=== Root Certificate ===
 +
 +This option defines path to the Root Certificate on the local machine.
 +
  
 ====== Teradata ====== ====== Teradata ======
  
 {{:sqlways:users-guide:wizard:choose-target-db:teradata_adv.png?400}} {{:sqlways:users-guide:wizard:choose-target-db:teradata_adv.png?400}}
 +
 +
 +===== Common Options =====
 +
 +
 +=== Convert CHAR To VARCHAR If Length Greater ===
 +
 +If this option is checked, SQLWays Wizard will convert all the CHAR columns, length of which is greater than the number specified in text box of this option, to VARCHAR with appropriate column length.
 +
 +
 +=== Query Band ===
 +
 +This option adds SET QUERY_BAND option for the current session or transaction in the generated FLD file. \\ Default value - Empty. 
 +
 +
 +=== Logging Mechanism ===
 +
 +In this option you can define logging mechanism that will be used to connect to the Teradata database. \\ Possible values - “LDAP”,”NTLM”, “Default” or Empty. \\ Default value - “Default” or Empty. 
  
  
Line 291: Line 333:
 === Use Fast Load === === Use Fast Load ===
  
-"Use fast load" option allows to use fastload.exe utility to load the data into the Teradata database. Also for fastload utility please specify such options like "Error files", "Sessions", "Tenacity", "Sleep", "Errors limit".+"Use fast load" option allows using fastload.exe utility to load the data into the Teradata database. Also for fastload utility please specify such options like "Error files", "Sessions", "Tenacity", "Sleep", "Errors limit". 
 + 
 + 
 +=== BIN Directory === 
 + 
 +Specifies the directory where FLOAD utility is located. Can be used only when "Use Fast Load" is checked.
  
 === Error Files === === Error Files ===
    
-"Error files" - You need to specify two error tables where fastload utility will put information about the errors that occur during the fastload execution. The first error table record translation or constraint violation error. Second error table stores errors related to duplication of values for Unique Primary Index. Default suffixes "_Err1" and "_Err2".+You need to specify two error tables where fastload utility will put information about the errors that occurred during the fastload execution. The first error table records translation or constraint violation error. Second error table stores errors related to duplication of values for Unique Primary Index. Default suffixes "_Err1" and "_Err2". Can be used only when "Use Fast Load" is checked.
  
-=== Error Limit ===+=== Errors Limit ===
    
-"Errors limit" - Need to specify maximum number of rejected errors that fastload utility will put in the first error table.+You need to specify the maximum number of rejected errors that fastload utility will put in the first error table. Can be used only when "Use Fast Load" is checked.
  
 === Sessions === === Sessions ===
    
-"Sessions" - This option controls the number of sessions to establish with Teradata database.+This option controls the number of sessions to be established with Teradata database. Can be used only when "Use Fast Load" is checked.
  
 === Tenacity === === Tenacity ===
  
-"Tenacity" - Specify the number of hours that fastload tries to establish the connection.+Specifies the number of hours during which fastload tries to establish the connection. Can be used only when "Use Fast Load" is checked.
  
 === Sleep === === Sleep ===
  
-"Sleep" - Works together with "Tenacity" option. It controls the number of minutes to wait before fastload retry to establish the connection.+Works together with "Tenacity" option. It controls the number of minutes to wait before fastload will retry to establish the connection. Can be used only when "Use Fast Load" is checked.
  
  
Line 433: Line 480:
  
  
-\\ +
-[[http://www.ispirer.com|Ispirer Home Page]] +
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]+
© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.