RE: How to Export Database Info to a MSWin based PC?

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.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. > > ______________________________________________________________ > __________ > 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