Received: from mailin10.email.bigpond.com ([139.134.6.87]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1709ax59127 for ; Tue, 6 Feb 2001 19:09:36 -0500 (EST) (envelope-from aa2@bigpond.net.au) Received: from bigpond.net.au ([139.134.4.50]) by mailin10.email.bigpond.com (Netscape Messaging Server 4.15) with SMTP id G8D1ZK00.C3A; Wed, 7 Feb 2001 10:14:08 +1000 Received: from CPE-144-132-75-163.vic.bigpond.net.au ([144.132.75.163]) by mail8.bigpond.com (Claudes-Hot-MailRouter V2.9c 17/6823005); 07 Feb 2001 10:08:45 Message-ID: <3A809215.7E8A9B3D@bigpond.net.au> Date: Wed, 07 Feb 2001 11:08:53 +1100 From: Justin Clift X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Manika Dey CC: Peter Mount , postgres-inter Subject: Re: different methods to transfer data References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/37 X-Sequence-Number: 990 Hi Manika, How are they stored on your WindowsNT systems? Are they already in some form of database? If you have ODBC connectivity in their already stored format, that is one way of doing it. If you can convert them to a CSV file, that is another way of doing it (there are drawbacks and benefits in this). Can you give us more info as to how it's presently stored (text file(s), MS SQL, MS Access, etc), what types of data, and so on? Regards and best wishes, Justin Clift Database Administrator/Programmer Manika Dey wrote: > > Hi, > we are acquiring data from systems on windows and > WindowsNT platform ,size of datafiles are in MB and gigabytes(GB) > My postgres database is installed on sun solaris platform. > > I would like to the know about the different methods or techniques > that i can apply to transfer the data from these systems(on windows/NT) > to my postgres (on Solaris platform) database. > All the systems (computer ) are well connected by > network. > > > > ------------------------------------------------------------------- > > From:- | > Ms. Manika Dey. |Ph.No:-- > Engineer-SC (Comp. Tech.) | IPR -- 02712 - 69276 > I.P.R | EXT 336,315 > BHAT, GANDHINAGAR | Residence -- 079 -7421117 > Gujrat -- 382 428 | FAX --- 69017 > ------------------------------------------------------------------ > > >