Received: from clubserv.rp-online.de (root@clubserv.rp-online.de [149.221.232.11]) by hub.org (8.9.1/8.9.1) with ESMTP id BAA18945 for ; Fri, 27 Nov 1998 01:29:10 -0500 (EST) (envelope-from meskes@usa.net) Received: from feivel.meskes.de (as9-asy46.rp-plus.de [149.221.92.110]) by clubserv.rp-online.de (8.9.1a/8.9.1) with ESMTP id HAA20784 for ; Fri, 27 Nov 1998 07:29:38 +0100 (MET) Received: (from meskes@localhost) by feivel.meskes.de (8.9.1a/8.9.0/Debian/GNU) id FAA00382 for pgsql-interfaces@postgreSQL.org; Thu, 26 Nov 1998 05:52:44 +0100 Date: Thu, 26 Nov 1998 05:52:42 +0100 From: Michael Meskes To: pgsql-interfaces Subject: Re: [INTERFACES] Postgresql vs. Access97, TransferDatabase Message-ID: <19981126055242.A374@usa.net> Mail-Followup-To: pgsql-interfaces References: <18D7589E9C44D21199AC00805F31B04708A0BA@atlanta_nt2.atlanta.glenayre.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.94.15i In-Reply-To: <18D7589E9C44D21199AC00805F31B04708A0BA@atlanta_nt2.atlanta.glenayre.com>; from Gilley, Charles H. on Wed, Nov 25, 1998 at 03:55:37PM -0500 On Wed, Nov 25, 1998 at 03:55:37PM -0500, Gilley, Charles H. wrote: > Okay, to provide some helpful feedback to others.... I readily admit that > I am still a novice at this, so feel free to chime in and correct any > misunderstandings that I may have. > > First, I've been trying to transfer a large dataset from access to postgres > using a variety of methods: > > ... > 1) Cut and paste from access table to linked table: Don't do this. It will run forever. Granted I never tried with postgres but I tried with Oracle once some months ago and I'm pretty sure it will still run hadn't I interrupted it. :-) > 3) Export table - I believe this is the same as cutting/pasting except that > it No, it is not the same. It is way faster. Michael -- Dr. Michael Meskes, Manager of the Western Branch Office, Datenrevision GmbH work: Cuxhavener Str. 36, D-21149 Hamburg, Michael.Meskes@datenrevision.de home: Th.-Heuss-Str. 61, D-41812 Erkelenz, Michael.Meskes@usa.net Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!