Skip site navigation (1) Skip section navigation (2)

Data Transfer from Postgresql to Sybase

From: "Karthick V" <karthickv(at)hclp(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>,<pgsql-admin(at)postgresql(dot)org>
Subject: Data Transfer from Postgresql to Sybase
Date: 2002-11-15 09:09:20
Message-ID: 002701c28c86$af7a7660$2a000050@eureka (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-novice
Hi 

I have a database in PostgreSQL. I need to transfer all the data from it to a sybase server located remotely. How do I do it. Is there any tool like DTS(MSSQL Server) to transfer the data.

Both my systems are on Linux and basically this functionality is a part of a larger database application where if the connection is lost from the sybase server. The data is stored in the local machine using postgresql. 

So I need to send only a certain amount of data. to update the sybase server. I am able to get a dump of the tables using pg_dump command for postgresql. 

If I could call the application using parameters specifying which tables are to be moved, then It should be able to transfer the data.

Otherwise will I have to do it manually using a C program or something like that.

Has anyone done such a transfer earlier?

:-)
karthick v



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002

pgsql-novice by date

Next:From: Ludwig LimDate: 2002-11-15 09:50:47
Subject: core dump in psql (Is it a bug?)
Previous:From: Joel RodriguesDate: 2002-11-15 04:30:33
Subject: using functions to generate custom error messages

pgsql-admin by date

Next:From: Jodi KanterDate: 2002-11-15 13:27:06
Subject: Re: VACUUM
Previous:From: Jorge SaumaDate: 2002-11-15 04:29:15
Subject: Missing data frrom a shutdown

pgsql-general by date

Next:From: Henrik SteffenDate: 2002-11-15 10:11:06
Subject: Re: [PERFORM] Upgrade to dual processor machine?
Previous:From: Cedric Dufour (Cogito Ergo Soft)Date: 2002-11-15 08:47:23
Subject: Re: [GENERAL] Upgrade to dual processor machine?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group