| 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 | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jodi Kanter | 2002-11-15 13:27:06 | Re: VACUUM | 
| Previous Message | Jorge Sauma | 2002-11-15 04:29:15 | Missing data frrom a shutdown | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Steffen | 2002-11-15 10:11:06 | Re: [PERFORM] Upgrade to dual processor machine? | 
| Previous Message | Cedric Dufour (Cogito Ergo Soft) | 2002-11-15 08:47:23 | Re: [GENERAL] Upgrade to dual processor machine? | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludwig Lim | 2002-11-15 09:50:47 | core dump in psql (Is it a bug?) | 
| Previous Message | Joel Rodrigues | 2002-11-15 04:30:33 | using functions to generate custom error messages |