Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 11DE12E2DD8 for ; Thu, 15 Nov 2007 13:15:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 34019-09 for ; Thu, 15 Nov 2007 13:15:01 -0400 (AST) Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 848682E2DAB for ; Thu, 15 Nov 2007 13:15:00 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Thu, 15 Nov 2007 11:14:57 -0600 Message-Id: <473C2A26.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Thu, 15 Nov 2007 11:14:46 -0600 From: "Kevin Grittner" To: "Cristiano Marques" , Subject: Re: help to Brazil References: <3edb6f2c0711141405j70a002eaqca12047ae4f87c23@mail.gmail.com> <3edb6f2c0711141408p206150ebobec87ecd203243e3@mail.gmail.com> In-Reply-To: <3edb6f2c0711141408p206150ebobec87ecd203243e3@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/153 X-Sequence-Number: 27396 >>> On Wed, Nov 14, 2007 at 4:08 PM, in message <3edb6f2c0711141408p206150ebobec87ecd203243e3@mail.gmail.com>, "Cristiano Marques" wrote:=20 =20 > I have necessity of integrate a data base > Sybase and data base Postgresql. The propose is migration data of > approximate 7000 tables. >=20 > I like make cluster of two bases. >=20 > Is possible? =20 We're near the end of migrating our 100 databases from Sybase to PostgreSQL, so I might be able to give you some hints. To know where to even start, I'd have to know more about your software environment; the conversion itself is not all that hard, but getting the same version of the software to run against both products was a little tricky, even using a framework designed with portability as a very high priority. (If you just scatter the SQL code around your applications in string literals, you're going to have a very hard time of it.) =20 For a while we actually ran our web site with the renderers doing load balancing between Sybase and PostgreSQL databases. The exact same code was used for both except for a portability layer of a few hundred lines of code for each product and (of course) the JDBC drivers. So yes, it is *possible*. =20 -Kevin =20