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 [October 12, 2018, 01:00:29 PM] – [Sleep] darya.prikhodkinasqlways: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 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 ======
Line 456: 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.