Thread: different methods to transfer data
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(onwindows/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,315BHAT, GANDHINAGAR | Residence -- 079 -7421117
Gujrat-- 382 428 | FAX --- 69017 ------------------------------------------------------------------
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.
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 > ------------------------------------------------------------------ > > >