From: Chairudin Sentosa <chairudin@prima.net.id>
To: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Update Postgresql auto from SQL Server 6.5
Date: Mon, 29 Mar 1999 06:46:46 -0700
Message-ID: <36FF8446.2DC1D3F1@prima.net.id> (raw)
References: <199903290210.LAA00030@kmail.com>
<36FF1CC9.3DE5BE66@flex.ro>
Hi friends,
I have a Linux + Postgresql machine and an SQL Server 6.5 machine.
There is one table (usage-detail) in SQL Server keeps getting data every seconds.
Now, I want data from table (usage-details) in SQL Server to show up in postgresql in real time (if possible).
What I am doing now is:
1. Spool the table (usage-details) from SQL Server 6.5 every 30 minutes.
2. Ftp the file to Linux machine
3. Use perl to run 'insert' command to insert data to table (usage-details) in Postgresql.
I would like to do it automatically, without doing any spooling or ftping.
How to do it?
I want that one table (usage-details) keeps synchronized between postgresql and SQL Server 6.5
Can anyone help me, please?
Thank you for your help.
Regards,
Chai
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: chairudin@prima.net.id
Subject: Re: Update Postgresql auto from SQL Server 6.5
In-Reply-To: <36FF8446.2DC1D3F1@prima.net.id>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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