Re: Moving from SQL Anywhere to PostGres - First Time - Mailing list pgsql-general

From Michael Gould
Subject Re: Moving from SQL Anywhere to PostGres - First Time
Date
Msg-id 393bf55cebd45c71fec623552acbd718@intermodalsoftwaresolutions.net
Whole thread Raw
In response to Moving from SQL Anywhere to PostGres - First Time  ("Robert Paresi" <firstname@lastname.net>)
Responses Re: Moving from SQL Anywhere to PostGres - First Time
List pgsql-general
Robert,

We used Data Manager from JP to do this.  Worked well.  He recently added
the ability to read OEM versions of ASA.  How's come your moving away from
SQL Anywhere?

Best Regards

Mike Gould

"Robert Paresi" <firstname@lastname.net> wrote:
> Hello,
>
> We have 700 user install base using Sybase SQL Anywhere 9.02
>
> We are looking at migrating these installations over to PostGres
>
> 1.  Very Very Short Answer Please - why should we?
>
> 2.  Does anyone have a utility or migration application to read SQL
Anywhere
> to go to PostGres
>
> 3.  Does PostGres handle column descriptions (ie: you can give each column
a
> 50 character description) and then access it via SQL Result Set (like I
can
> do in Sybase)
>
> 4.  Is there any Date/TimeStamp issues and conversions I need to know
about.
> I use simply a DATE field and a TIME field - but do not use DATE/TIME
stamp
> fields together.
>
> 5.  What UI/Developer tools (GUI) are available to manage the database as
> well as add/change columns rather than doing it via SQL commands.
>
> Thank  you.
>
> -Robert
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Moving from SQL Anywhere to PostGres - First Time
Next
From: Ralph Smith
Date:
Subject: A Query that works standalone but not in a f(x)