RE: EnterpriseDB
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <ineyman@xxxxxxxxxxxxxx>, <rjfeighery@xxxxxxxxx>, "Oracle-L List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Feb 2007 15:54:10 -0500
Igor,
Your right, I stand corrected.
Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA
Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795
RGoulet@xxxxxxxxxx
: POWERING TRANSFORMATION
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Igor Neyman
Sent: Wednesday, February 21, 2007 10:19 AM
To: Richard J. Goulet; rjfeighery@xxxxxxxxx; Oracle-L List
Subject: RE: EnterpriseDB
Small correction.
In PG the database can have multiple tablespaces (just one - default).
You can specify tablespace as "storage" parameter when creating a table,
if not specified - it goes into "default" tablespace.
The biggest "eye-opener" for me was the fact, that in PG every table is
stored in a separate file.
Igor
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Richard J. Goulet
Sent: Wednesday, February 21, 2007 9:55 AM
To: rjfeighery@xxxxxxxxx; Oracle-L List
Subject: RE: EnterpriseDB
YES, It's not a bad product, but there is a substantial amount of
reading between the lines that you'll need doing. The underlying
technology is PostGreSql which you can acquire for free from
postgres.org. Migration is simple as they fully support functions and
some procedures. I didn't see packages in PostGreSql so I believe
EnterpriseDB's migration tool breaks them up into separate entities.
Also PostGreSql's interpretation of tablespaces is different that ours.
Where as in Oracle a database can have multiple tablespaces in
postgresql they can have only one, but different databases can each have
a separate tablespace or storage location. A lot better than MySql or
Sql*Server, but not quite the same as Oracle. Also if your into
clustering or replication your either stuck (no clustering yet in
PostGreSql) or you have to use a third party tool which are also open
sourced so not a really big deal. It works really great for decision
support or trend analysis, or even a customer facing application like
order status stuff. No it would not run an SAP or E-Business Suite like
application very well and I would not want to store sensitive data
therein either. But it is an attractive alternative to Oracle from a
cost perspective. And acquiring it from EnterpriseDB vs. Postgresql.org
does give you a phone number to call when the mess hits the fan.
Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA
Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795
RGoulet@xxxxxxxxxx
: POWERING TRANSFORMATION
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Feighery
Sent: Wednesday, February 21, 2007 12:46 AM
To: Oracle-L List
Subject: EnterpriseDB
Has anyone used this?
http://www.enterprisedb.com/solutions/gotoracle.do
"EnterpriseDB offers an enterprise-class alternative to Oracle at a
fraction of the cost.
....
Making the switch from Oracle requires little or no modification to
existing applications. Using our Migration Toolkit, the process is often
completed in minutes. In fact, our clients report that more than 75% of
their applications are 100% compatible, requiring NO changes to run on
EnterpriseDB.
...
Some EnterpriseDB clients choose to entirely replace Oracle; others use
our databases as a more efficient alternative for specific applications
and reports.
...
EnterpriseDB Advanced Server is based on PostgreSQL"
Ray
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
