TABLE 11. 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 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 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 and Triggers
|
|
Oracle
|
Tables (Default values, Null properties, Check and Unique constraints, Primary and Foreign Keys, Comments), Indexes and Views
|
|
Microsoft SQL Server
|
Tables (Default values, Null and Identity properties, Check and Unique constraints, Primary and Foreign Keys), Indexes and Views
|
|
Sybase Adaptive Server Enterprise
|
Tables (Default values, Null and Identity properties , Check and Unique constraints , Primary and Foreign Keys), Indexes and Views
|
|
Sybase Adaptive Server Anywhere, Sybase SQL Anywhere
|
Tables (Default values, Null and Identity properties , Check and Unique constraints , Primary and Foreign Keys), Indexes and Views
|
|
Informix
|
Tables (Default values, Null properties , Check and Unique constraints , Primary and Foreign Keys) and Indexes
|
|
MySQL
|
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
|
|
dBase, FoxPro, Excel, Paradox, Interbase, Gupta SQLBase and any other ODBC-compliant database
|
Tables (Default values, Null properties , Primary Keys) and Indexes
|
