TABLE 7. Database Object and Features Support for Oracle
Source
|
Target - Oracle
|
IBM DB2 for Linux, Unix and Windows
|
Tables (Default values, Null and Identity properties, Primary and Foreign Keys, Check and Unique constraints, Comments), Indexes, Views, Sequences, Stored Procedures, Functions and Triggers
|
IBM DB2 for z/OS, OS/390 and MVS
|
Tables (Default values, Null and Identity properties, Primary and Foreign Keys, Check and Unique constraints, Comments), Indexes, Views, Sequences, Stored Procedures, Functions 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, Sequences, Stored Procedures, Functions and Triggers
|
Oracle
|
Tables (Default values, Null properties, Primary and Foreign Keys, Check and Unique constraints, Comments), Indexes, Views, Sequences, Users, Stored Procedures, Functions and Triggers
|
Microsoft SQL Server
|
Tables (Default values, Null and Identity properties, Primary and Foreign Keys, Check and Unique constraints), Indexes, Views, Stored Procedures, Functions and Triggers
|
Sybase Adaptive Server Enterprise
|
Tables (Default values, Null and Identity properties , Primary and Foreign Keys, Check and Unique constraints), Indexes, Views, Stored Procedures, Functions and Triggers
|
Sybase Adaptive Server Anywhere, Sybase SQL Anywhere
|
Tables (Default values, Null and Identity properties, Primary and Foreign Keys , Check and Unique constraints), Indexes, Views, Stored Procedures, Functions and Triggers
|
Informix
|
Tables (Default values, Null and Serial properties , Primary and Foreign Keys, Check and Unique constraints), Indexes, Views, Stored Procedures, Functions, Triggers and 4GL Applications (Logic, Forms and Reports)
|
MySQL
|
Tables (Default values, Null and Auto-increment properties , Primary and Foreign Keys, Unique constraints ), Indexes, Views, Stored Procedures, Functions and Triggers
|
PostgreSQL
|
Tables (Default values, Null properties, Primary and Foreign Keys, Check and Unique constraints), Indexes, Views, Sequences, Stored Procedures, Functions and Triggers
|
Progress
|
Tables (Default values, Null properties, Primary and Foreign Keys, Check and Unique constraints), Indexes, Views, Synonyms, 4GL Code
|
Pervasive.SQL
|
Tables (Default values, Null properties, Primary and Foreign Keys), Indexes and Views
|
Microsoft Access
|
Tables (Default values, Null and Identity properties , Primary and Foreign 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
|