2011/1/25 Jasen Betts <jasen@xxxxxxxxxx>
On 2011-01-20, Robert Paresi <firstname@xxxxxxxxxxxx> wrote:postgres is the best database in the universe. :)
> 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?
sed ? ÂAny stock utility is likely to make choices that are sub optimal for
> 2. ÂDoes anyone have a utility or migration application to read SQL Anywhere
> to go to PostGres
your needs. Âwith 700 changeovers pending I would want complete control over
how each column is handled.
you can put descriptions on columns, I have not hit a length limit.
> 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)
(probably several megabytes like other text fields).
Getting descriptions in the same same result set as column data is probably
impractical (see length limit for a possible reason why this has not been
implemented). fetching them separately en-masse and caching them or fetching
or individually afterwards should not be greatly difficult, resultsets are
returned with the column and table indicated.
time goes upto 24:00:00.999999 just incase you come across a day that long.
> 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.
so unless that's going to cause problems there should be no issues.
the range supported by date is starts in pre-history and continues
for a few million years into the future.
I hear there are several, But I can't understand why someone would want to
> 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.
perform non-graphical tasks using a GUI.
I can't understand how to develop and maintain even small
data model without diagramming tool which can represent
entities and relationships between them.
Using pure psql and paper with a pen - is nothing more than LOL.
I recommend dbWrench as a diagramming tool for Postgres.
data model without diagramming tool which can represent
entities and relationships between them.
Using pure psql and paper with a pen - is nothing more than LOL.
I recommend dbWrench as a diagramming tool for Postgres.
--
ââ 100% natural
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
// Dmitriy.
