pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSql Anywhere to PostgreSQL?
3+ messages / 3 participants
[nested] [flat]
* Sql Anywhere to PostgreSQL?
@ 2006-10-24 20:48 Chris Hoover <revoohc@gmail.com>
2006-10-25 08:44 ` Re: Sql Anywhere to PostgreSQL? Shane Ambler <pgsql@007Marketing.com>
2006-10-26 01:17 ` Re: Sql Anywhere to PostgreSQL? ljb <lbayuk@pobox.com>
0 siblings, 2 replies; 3+ messages in thread
From: Chris Hoover @ 2006-10-24 20:48 UTC (permalink / raw)
To: pgsql-admin
Has anyone ever done a conversion from Sql Anywhere to PostgreSQL? I have a
task to investigate what this would take.
Also, the Sql Anywhere database stores image files in the database as long
binary types. What would be the best format to store these in PostgreSQL?
Also, while all of my current PG clusters are on RH linux, if this project
went forward, it would have to run on Windows 2k. Will the windows version
of PG run on 2k, and are there any special caviates running on this
platform?
Thanks,
Chris
PG 8.1.3
RH 4.0 AS
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Sql Anywhere to PostgreSQL?
2006-10-24 20:48 Sql Anywhere to PostgreSQL? Chris Hoover <revoohc@gmail.com>
@ 2006-10-25 08:44 ` Shane Ambler <pgsql@007Marketing.com>
1 sibling, 0 replies; 3+ messages in thread
From: Shane Ambler @ 2006-10-25 08:44 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin
Chris Hoover wrote:
> Has anyone ever done a conversion from Sql Anywhere to PostgreSQL? I
> have a
> task to investigate what this would take.
>
> Also, the Sql Anywhere database stores image files in the database as long
> binary types. What would be the best format to store these in PostgreSQL?
That would be bytea or blob depending on your exact needs.
> Also, while all of my current PG clusters are on RH linux, if this project
> went forward, it would have to run on Windows 2k. Will the windows version
> of PG run on 2k, and are there any special caviates running on this
> platform?
PostgreSQL 8.0 and above runs on windows and is available in a
pre-configured windows installer package to install like other software.
The main catch is the windows version is somewhat newer and less tested
than the *nix versions. (previous versions on windows where the *nix
source built on top of cygwin)
--
Shane Ambler
pgSQL@007Marketing.com
Get Sheeky @ http://Sheeky.Biz
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Sql Anywhere to PostgreSQL?
2006-10-24 20:48 Sql Anywhere to PostgreSQL? Chris Hoover <revoohc@gmail.com>
@ 2006-10-26 01:17 ` ljb <lbayuk@pobox.com>
1 sibling, 0 replies; 3+ messages in thread
From: ljb @ 2006-10-26 01:17 UTC (permalink / raw)
To: pgsql-admin
> Has anyone ever done a conversion from Sql Anywhere to PostgreSQL? I have a
> task to investigate what this would take.
Biggest problem areas I see would be stored procedures and the many SQL
differences. If you use stored procedures, they will need to be completely
rewritten. The SQL differences will get you too; someone who knows both
SQLA and PostgreSQL will have to review line-by-line. Stuff like SQLA's
"current timestamp" vs PostgreSQL "current_timestamp". Or, limiting returned
rows (SQLA: SELECT TOP 10 * FROM ... vs PostgreSQL: SELECT * FROM ... LIMIT
10). Just two examples. Where standards exist, PostgreSQL is much more
standard than Sybase.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-10-26 01:17 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-24 20:48 Sql Anywhere to PostgreSQL? Chris Hoover <revoohc@gmail.com>
2006-10-25 08:44 ` Shane Ambler <pgsql@007Marketing.com>
2006-10-26 01:17 ` ljb <lbayuk@pobox.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox