|
|
|
|
|
|
| Author |
Message |
Tomas Lanczos
*nix forums beginner
Joined: 22 Mar 2006
Posts: 6
|
 Posted: Sat Jul 08, 2006 7:02 pm Post subject:
RE: migration from Sybase to Postgres
|
|
|
| Quote: | [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
On 7 Jul 2006 12:50:22 -0000, lanczos@t-zones.sk
lanczos@t-zones.sk> wrote:
What is the most appropriate way to migrate a database form
Sybase (SQL Anywhere 5.504) to Postgres? I found some
shareware of freeware migration tools on the net, which are
the best? Is it faster to use any of them them or just simply
do it manually?
An excellent conversion tool is actually microsoft sql
server. It can convert via dts transformation to any odbc
source to any other odbc source if you have a windows machine
to do the conversion and a copy of the database.
|
Do You mean the SQL Server Express for free?
| Quote: | barring that, I would just dump sybase into sql statements
(does it support that?) and massage the text and pipe into psql.
|
Following my quick look into it does not support it.
Tomas
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq |
|
| Back to top |
|
 |
Merlin Moncure
*nix forums addict
Joined: 19 Oct 2005
Posts: 87
|
| Posted: Fri Jul 07, 2006 1:26 pm Post subject:
Re: migration from Sybase to Postgres
|
|
|
On 7 Jul 2006 12:50:22 -0000, lanczos@t-zones.sk <lanczos@t-zones.sk> wrote:
| Quote: | What is the most appropriate way to migrate a database form Sybase (SQL Anywhere 5.504) to Postgres? I found some shareware of freeware migration tools on the net, which are the best? Is it faster to use any of them them or just simply do it manually?
|
An excellent conversion tool is actually microsoft sql server. It can
convert via dts transformation to any odbc source to any other odbc
source if you have a windows machine to do the conversion and a copy
of the database.
barring that, I would just dump sybase into sql statements (does it
support that?) and massage the text and pipe into psql.
merlin
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org |
|
| Back to top |
|
|
Tomas Lanczos
*nix forums beginner
Joined: 22 Mar 2006
Posts: 6
|
| Posted: Fri Jul 07, 2006 12:50 pm Post subject:
migration from Sybase to Postgres
|
|
|
What is the most appropriate way to migrate a database form Sybase (SQL Anywhere 5.504) to Postgres? I found some shareware of freeware migration tools on the net, which are the best? Is it faster to use any of them them or just simply do it manually?
Thanks
Tomas
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Tue Jan 06, 2009 12:52 am | All times are GMT
|
|
Mortgage | Car Finance | Personal Injury Lawyer Los Angeles | Loans | Debt Consolidation
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
PostgreSQL
