Thread: migrating from progress dbms

migrating from progress dbms

From
miguel angel rojas aquino
Date:
hi, currently we are planning a migration from a progress db to
postgresql, and want to know if somebody has done the same, and what
issues have found during the process.

right now, the first thing we encounter is the fact that (at least in
jdbc) all the table and column names needs to be beteewn double
quotation marks. another is the fact that in progress exist an array
data type.

well, thanks in advance for any help you could provide, and best regards.


Re: migrating from progress dbms

From
Bruce Momjian
Date:
Lots of folks migrate from Progress.  It should be fine.

---------------------------------------------------------------------------

miguel angel rojas aquino wrote:
> hi, currently we are planning a migration from a progress db to
> postgresql, and want to know if somebody has done the same, and what
> issues have found during the process.
>
> right now, the first thing we encounter is the fact that (at least in
> jdbc) all the table and column names needs to be beteewn double
> quotation marks. another is the fact that in progress exist an array
> data type.
>
> well, thanks in advance for any help you could provide, and best regards.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: migrating from progress dbms

From
Bruce Momjian
Date:
Also, see techdocs.postgresql.org for porting guiedes.  Not sure if
Progress is in there.

---------------------------------------------------------------------------

miguel angel rojas aquino wrote:
> hi, currently we are planning a migration from a progress db to
> postgresql, and want to know if somebody has done the same, and what
> issues have found during the process.
>
> right now, the first thing we encounter is the fact that (at least in
> jdbc) all the table and column names needs to be beteewn double
> quotation marks. another is the fact that in progress exist an array
> data type.
>
> well, thanks in advance for any help you could provide, and best regards.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: migrating from progress dbms

From
"Gabriel Munteanu"
Date:
Theare are arrays inPostgresql too.



Re: migrating from progress dbms

From
Christoph Dalitz
Date:
On Mon, 27 Jan 2003 15:15:50 -0500
pgsql-general-owner@postgresql.org wrote:
>
> right now, the first thing we encounter is the fact that (at least in
> jdbc) all the table and column names needs to be beteewn double
> quotation marks.
>
Don't use double quotes unless you are asking for trouble!
Double quotes are used for case sensitive identifiers or identifiers
with whitespace characters. Usage of these features is not a good idea.

If you have found that you need them in queries, then your CREATE statements
used case sensitive table/attribute names. This will be a continuous source
of pain and I strongly recommend that you fix your CREATE statements.

Christoph Dalitz