How to Export Database Info to a MSWin based PC?
Posted in 2004
Topics: Connectivity: ODBC / JDBC / .NET, Java & JDBC Development
I am totally new to Informix and Unix. I have been presented with a database system running Unix and is using an IBM Informix v5.1 database. I need to export the database info to any PC/notebook running an MSWin OS(such as WinME). Can someone help me out and tell me what to do-how to connect the machines up and what drivers/programs to use for the data export. Thanks. p.s. I was initially planning to write a Java JDBC program to do the communication, but got lost in what to do. But also, as I am new to this database, it will be difficult to determine the versions etc.
dbexport will create, in your current directory, the database's
DDL/schema/SQL to build it, plus a series of pipe-delimited ASCII files
containing the daya which, with a little ingenuity, you should be able to
adapt.
Then you can tar up the database.exp directory and ftp it to your PC, using
WinZip to extract the tar archive.
Is this what you meant?
"Lionel Chin" <ywchin@singnet.com.sg> wrote in message
news:b7ce25f9.0408112303.60aa48af@posting.google.com...
> I am totally new to Informix and Unix. I have been presented with a
> database system running Unix and is using an IBM Informix v5.1
> database.
>
> I need to export the database info to any PC/notebook running an MSWin
> OS(such as WinME). Can someone help me out and tell me what to do-how
> to connect the machines up and what drivers/programs to use for the
> data export.
>
> Thanks.
>
> p.s. I was initially planning to write a Java JDBC program to do the
> communication, but got lost in what to do. But also, as I am new to
> this database, it will be difficult to determine the versions etc.
Perhaps some of it might be. Maybe I hadn't given enough info about
the scenario.
The database that I am trying to export is rather large, so I was
wondering what kind of physical connection between the machines I
should begin with-serial, parallel, ethernet? Again, this is not
knowing how Unix and its available programs work with communication
ports.
What I would like to do is to export the informix database into a
universal format so that when I update to a up-to-date database
system, there will be no problem putting back the data into my new
database.
At the moment, I want to use a MSWin based PC to store the database
information. What kinds of connections and programs do I need? What do
I need to do with them?
Thanks again.
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2o0nq3F5fl88U1@uni-berlin.de>...
> dbexport will create, in your current directory, the database's
> DDL/schema/SQL to build it, plus a series of pipe-delimited ASCII files
> containing the daya which, with a little ingenuity, you should be able to
> adapt.
>
> Then you can tar up the database.exp directory and ftp it to your PC, using
> WinZip to extract the tar archive.
>
> Is this what you meant?
>
> "Lionel Chin" <ywchin@singnet.com.sg> wrote in message
> news:b7ce25f9.0408112303.60aa48af@posting.google.com...
> > I am totally new to Informix and Unix. I have been presented with a
> > database system running Unix and is using an IBM Informix v5.1
> > database.
> >
> > I need to export the database info to any PC/notebook running an MSWin
> > OS(such as WinME). Can someone help me out and tell me what to do-how
> > to connect the machines up and what drivers/programs to use for the
> > data export.
> >
> > Thanks.
> >
> > p.s. I was initially planning to write a Java JDBC program to do the
> > communication, but got lost in what to do. But also, as I am new to
> > this database, it will be difficult to determine the versions etc.