| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Roy Anderson <roy(dot)anderson(at)gmail(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Oracle to PostgreSQL transition? |
| Date: | 2013-04-05 16:12:06 |
| Message-ID: | 515EF7D6.3050802@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 04/04/2013 09:16 AM, Roy Anderson wrote:
> We have a very robust Oracle and SQL Server presence at work but we're
> looking to farm out some of the load to PostgreSQL to limit costs.
You can do what we did. EnterpriseDB has built-in Oracle compatibility
through a series of plugins, patches, and wrappers. You can generally
convert with only a few small changes.
From there, you can take your time converting to PG syntax and go
through more iterations in your dev and staging environments.
If it's early enough in the lifetime of your platform, you could also
just convert everything at once. That's not always an option for
everyone though. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2013-04-05 16:28:18 | Re: Oracle to PostgreSQL transition? |
| Previous Message | Dmitriy Igrishin | 2013-04-05 15:41:27 | Re: Bug or feature? (The constraint of the domain of extension can be dropped...) |