X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B3890D1EC6C for ; Sat, 3 Apr 2004 10:07:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 86228-10 for ; Sat, 3 Apr 2004 06:07:05 -0400 (AST) Received: from remix.pl (bn162.internetdsl.tpnet.pl [80.53.197.162]) by svr1.postgresql.org (Postfix) with ESMTP id 06ADAD1E9F4 for ; Sat, 3 Apr 2004 06:06:51 -0400 (AST) Received: from wojtkiewiczm ([80.53.197.162]) by remix.pl with MailEnable ESMTP; Sat, 03 Apr 2004 12:06:09 +0200 From: "Mariusz Wojtkiewicz" To: Subject: PostgreSQL and MS SQL Server 2000 Date: Sat, 3 Apr 2004 12:06:58 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C41974.2A244FA0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcQZYziQE+//t9eVQgmADC0MJ792Pw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-Id: <20040403100651.06ADAD1E9F4@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_70_80, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200404/62 X-Sequence-Number: 13035 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C41974.2A244FA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi ! My name is Mariusz Wojtkiewicz, im from Poland. In my company we using base "MS SQL Server 2000". In next time we will need new base in next office. Our deliverer suggest as to use free base "PostgreSQL" put on free Linux. All is fine and beautiful but is one problem: We will need transfer all tables and record and changes from "PostgreSQL" to "MS SQL Server 2000" in head office. Is in "PostgreSQL" "replication mechanism" which will be allow: 1) transfer all tables, records and changes from It to "MS SQL Server 2000" 2) work it in "automatic mode" 3) make it in "nearly real mode" or minimum every half hour 4) get inversely changes (from "MS SQL Server 2000" to "PostgreSQL") 5) make all through Internet (TCP/IP) Regards Mariusz Wojtkiewicz Seeger Dach Sp. z o.o. Lebieniec 64 POLAND ------=_NextPart_000_0000_01C41974.2A244FA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi !

My name is Mariusz Wojtkiewicz, im from Poland.

In my company we using base “MS SQL Server = 2000”.

In next time we will need new base in next office= .

Our deliverer suggest as to use free base “= PostgreSQL” put on free Linux.

All is fine and beautiful but is one problem:

We will need transfer all tables and record and changes from “PostgreSQL” to “MS SQL Server 2000” in = head office.

Is in “PostgreSQL” “replication= mechanism”  which will be allow:

1)      = transfer all tables, records and changes from It to “MS SQL Server 2000”

2)      = work it in “automatic mode”

3)      = make it in “nearly real mode” or minimum every half hour<= /span>

4)      = get inversely changes (from “MS SQL Server 2000” to = “PostgreSQL”)

5)      = make all through Internet (TCP/IP)

 

 

Regards

M= ariusz Wojtkiewicz

Seeger Dach Sp. z o.o.

Lebieniec 64

POLAND

 

------=_NextPart_000_0000_01C41974.2A244FA0--