SEO

Lionel Chin wrote

> 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,
How large ? 1MB, 100MB, 1 GB, 100 GB, 1 TB
> 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.
If you do not know which to use, I think that rules out parallel. If
your database is larger than 10K that probably makes serial impractical.
Do you have any support to help you set up an ethernet connection ? If
not you are probably dead in the water.
>
> What I would like to do is to export the informix database
> into a universal format
I think that will be CSV ( Comma separated variables ) for data, I do
not know of any universal format for schemas.

>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.
You will probably have to rebuild from scratch every time to keep things
simple.
>
> At the moment, I want to use a MSWin based PC to store the
> database information. What kinds of connections
Realistically an ethernet connection
> and programs
Informix, MySQL, MS SQL ... The list is almost endless
> do I need? What do I need to do with them?
If you use Informix you can set up a direct connection or use
Dbexport/Dbimport.
Anything else I think you need to read a lot of manuals or pay for some
consultancy.
I hear Neil Truby's company is good, but that was from Neil :-) (see
email address below)

And if you do not know which program you are going to use on MS Win,
what are you going to do with the data? More manuals.

Colin Bull

>
> 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.c om...
> > > 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.
>
> __________________________________________________ ____________
> __________
> This email has been scanned for all known viruses by the
> MessageLabs Email Security System.
> __________________________________________________ ____________
> __________
>
>

__________________________________________________ ______________________
This email has been scanned for all known viruses by the MessageLabs Email
Security System.
__________________________________________________ ______________________

sending to informix-list

If I used dbexport, this will create a new file with the database info
in it without affecting the original file right? Is there a standard
filename extension for the database files? (i.e. *.frm or *.sql etc.)

Then the next step is to figure out how to transfer this new file from
the Unix PC to the WinME PC.

On Thu, 19 Aug 2004 03:13:19 -0400, Lionel Chin wrote:

> If I used dbexport, this will create a new file with the database info in it
> without affecting the original file right? Is there a standard filename
> extension for the database files? (i.e. *.frm or *.sql etc.)
>
> Then the next step is to figure out how to transfer this new file from the
> Unix PC to the WinME PC.

Dbexport creates an extract directory, <databasename>.exp. In there you will
find a schema file, <databasename>.sql, and a data extract, pipe delimited,
file for each table. The names of the files are mangled, and have the
extension .unl, but are noted in comments in the schema file before each
CREATE TABLE command.

Art S. Kagel