Thread: Data Transfer from Postgresql to Sybase
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
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
> Date: Fri, 15 Nov 2002 14:39:20 +0530 > From: "Karthick V" <karthickv@hclp.com> > > I have a database in PostgreSQL. I need to transfer all the data from it to a sybase server located remotely. How do Ido it. Is there any tool like DTS(MSSQL Server) to transfer the data. > What about "pg_dump --insert"? It creates an SQL-Script that you can import in any SQL database. Christoph Dalitz > To: <pgsql-general@postgresql.org>, <pgsql-novice@postgresql.org>, > <pgsql-admin@postgresql.org> > Is cross posting to several PG lists a common practice?