TABLE 12. Database Object and Features Support for Pervasive.SQL
Source
|
Target - Pervasive.SQL
|
IBM DB2 for Linux, Unix and Windows
|
Tables (Default values, Null and Identity properties, Check and Unique constraints, Primary and Foreign Keys, Comments), Indexes, Views, Stored Procedures and Triggers
|
IBM DB2 for z/OS, OS/390 and MVS
|
Tables (Default values, Null and Identity properties, Check and Unique constraints, Primary and Foreign Keys, Comments), Indexes, Views, Stored Procedures and Triggers
|
IBM DB2 for iSeries and AS/400
|
Tables (Default values, Null and Identity properties, Check and Unique constraints, Primary and Foreign Keys, Comments), Indexes, Views, Stored Procedures and Triggers
|
Oracle
|
Tables (Default values, Null properties, Check and Unique constraints, Primary and Foreign Keys, Comments), Indexes, Views, Stored Procedures and Triggers
|
Microsoft SQL Server
|
Tables (Default values, Null and Identity properties, Check and Unique constraints, Primary and Foreign Keys), Indexes, Views, Stored Procedures and Triggers
|
Sybase Adaptive Server Enterprise
|
Tables (Default values, Null and Identity properties , Check and Unique constraints , Primary and Foreign Keys), Indexes, Views, Stored Procedures and Triggers
|
Sybase Adaptive Server Anywhere, Sybase SQL Anywhere
|
Tables (Default values, Null and Identity properties , Check and Unique constraints , Primary and Foreign Keys), Indexes, Views, Stored Procedures and Triggers
|
Informix
|
Tables (Default values, Null properties , Check and Unique constraints , Primary and Foreign Keys), Indexes, Views, Stored Procedures and Triggers
|
MySQL
|
Tables (Default values, Null and Identity properties , Primary Keys) and Indexes
|
PostgreSQL
|
Tables (Default values, Null and Identity properties , Primary
Keys) and Indexes
|
Progress
|
Tables (Default values, Null and Identity properties , Primary
Keys) and Indexes
|
Pervasive.SQL
|
Tables (Default values, Null properties , Primary and Foreign Keys), Indexes and Views
|
Microsoft Access
|
Tables (Default values, Null and Identity properties , Primary Keys) and Indexes
|
Interbase, Firebird
|
Tables (Default values, Null property , Primary and Foreign Keys, Check and Unique constraints), Indexes,Generators, Views, Stored Procedures, Functions and Triggers
|
dBase, FoxPro, Excel, Paradox, Interbase, Gupta SQLBase, Clipper and any other ODBC-compliant database
|
Tables (Default values, Null properties , Primary Keys) and Indexes
|