pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: different methods to transfer data
3+ messages / 3 participants
[nested] [flat]
* Re: different methods to transfer data
@ 2001-02-06 08:47 Jean-Francois Burdet <Jean-Francois.Burdet@adm.unige.ch>
parent: Manika Dey <bithi@plasma.ernet.in>
1 sibling, 0 replies; 3+ messages in thread
From: Jean-Francois Burdet @ 2001-02-06 08:47 UTC (permalink / raw)
To: pgsql-interfaces
I had success importing windows hosted database to postgresql using the
ODBC driver.
I.e. MS-Access -> Export -> ODBC
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* different methods to transfer data
@ 2001-02-06 17:18 Manika Dey <bithi@plasma.ernet.in>
0 siblings, 2 replies; 3+ messages in thread
From: Manika Dey @ 2001-02-06 17:18 UTC (permalink / raw)
To: Peter Mount <petermount@maidstone.gov.uk>; +Cc: pgsql-interfaces
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
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: different methods to transfer data
@ 2001-02-07 00:08 Justin Clift <aa2@bigpond.net.au>
parent: Manika Dey <bithi@plasma.ernet.in>
1 sibling, 0 replies; 3+ messages in thread
From: Justin Clift @ 2001-02-07 00:08 UTC (permalink / raw)
To: Manika Dey <bithi@plasma.ernet.in>; +Cc: Peter Mount <petermount@maidstone.gov.uk>; pgsql-interfaces
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
> ------------------------------------------------------------------
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-02-07 00:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-06 17:18 different methods to transfer data Manika Dey <bithi@plasma.ernet.in>
2001-02-06 08:47 ` Jean-Francois Burdet <Jean-Francois.Burdet@adm.unige.ch>
2001-02-07 00:08 ` Justin Clift <aa2@bigpond.net.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox