Received: from lectoure.ghs.fr (IDENT:root@e009.paris-88.cybercable.fr [212.198.88.9]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA98888 for ; Wed, 2 Feb 2000 15:05:45 -0500 (EST) (envelope-from nhuillard@ghs.fr) Received: from agen.int.ghs (agen.int.ghs [192.168.200.21]) by lectoure.ghs.fr (8.8.7/8.8.7) with SMTP id VAA03914 for ; Wed, 2 Feb 2000 21:05:43 +0100 Received: by agen.int.ghs with Microsoft Mail id <01BF6DC1.43F6D9B0@agen.int.ghs>; Wed, 2 Feb 2000 21:05:42 +0100 Message-ID: <01BF6DC1.43F6D9B0@agen.int.ghs> From: Nicolas Huillard To: "'Achillefs Margaritis'" , "'pgsql-interfaces@hub.org'" Subject: RE: [INTERFACES] database migration Date: Wed, 2 Feb 2000 21:05:41 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id PAA99010 I will soon be using an open software written in VB, that is able to "replicate" the data between two different ODBC sources. It can only handle the same data structure between the two replicates, and not different ones. If you want it, I can send it to you off-list. Nicolas Huillard -----Message d'origine----- De: Achillefs Margaritis [SMTP:archiver@db.geocrawler.com] Date: mercredi 2 février 2000 20:19 À: pgsql-interfaces@hub.org Objet: [INTERFACES] database migration This message was sent from Geocrawler.com by "Achillefs Margaritis" Be sure to reply to that address. We have two different databases for two different products which do the same thing and contain the same information in MS SQL server, but we would like to keep both databases synchronized with the same data. Both applications are management information systems handling the same kind of information, but we have a newer implementation with a better database. But we would like both databases to contain the same data, and when the user enters data in one of the products, these data should show automatically in the DB of the other product. Do you know such a tool? We would like one that automates the task of keeping tables in any of the databases updated, indepentant of the way the changes come. www.ims.gr Geocrawler.com - The Knowledge Archive ************