About Ispirer Systems

Ispirer Home Page Database Migration Application Conversion Downloads


Usage examples of the sqlways_db.ini options

The example below shows the difference in the resulting function in both cases. Please compare and try:

Source PostgreSQL (Default)
(DROP_TABLE_CASCADE_CONSTRAINTS=Yes )
PostgreSQL
(DROP_TABLE_CASCADE_CONSTRAINTS=No)
 create table tab
(
  col1 number(12,0) not null,
  col2 number(4,0)
) 
 drop table tab;
create table tab
(
    col1 bigint not null,
    col2 smallint
); 
 create table tab
(
    col1 bigint not null,
    col2 smallint
); 


If this option does not work as expected, please contact our technical team: support@ispirer.com