Oracle to Postgres Migration - PGCon
[Pages:58]Oracle to Postgres Migration
Presented by Gurjeet Singh
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
Agenda
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
Schema Migration
A.K.A "User" in Oracle Oracle gives every user her own schema, by default
Names of schema, tables, columns, functions, ... Oracle converts them to UPPER CASE, unless quoted Postgres converts them to lower case, unless quoted You're safe if application quotes/does not quote the identifiers
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
Schema Migration
CREATE TABLE is mostly compatible, except
Virtual Columns: Use views Data Types
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
Schema Migration
Primary Key, Foreign Key, Unique, CHECK, NOT NULL
Btree / Descending: Works Reverse Key / Bitmap / Join: Not implemented (yet) Global: Feature not available
Hash, List, Range
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
Schema Migration
Not really the same thing as Oracle, but serves the same purpose
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
(C) EnterpriseDB Corporation 2011. All Rights Reserved. Company Confidential
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- oracle to postgresql migration mitigate risks with 4
- from oracle to postgresql
- oracle to postgres migration pgcon
- migrating oracle queries to postgresql
- porting oracle applications to postgresql
- oracle database 11g 12c to amazon aurora with postgresql
- oracle to postgresql migration a hard way
- porting from oracle to postgres v2
Related searches
- exchange 2010 to 2016 migration cas
- state to state migration map
- application for migration to canada
- german migration to the us
- exchange migration 2010 to 2016
- migration to america
- migration to america 1600s
- california migration to other states
- migration to canada requirements
- california migration to arizona
- black migration to california
- history of migration to california