Re: informix newbie

Daniel wrote: > Hi all, > > I downloaded the latest version of Informix (9+) for Windows. > > I was wondering if there was a way to do a complete database backup, save > it to a file, and bring this file to another installation of Informix > (also 9+) and do a restore? I would like to copy all tables, objects, and > data. If possible, how would I do this? Loads of ways -- dbexport/dbimport or take an ontape or onbar backup. Also onunload and onload, or dbschema and unload/load (or dbload). > For each database, where does Informix keep the file? I have my > installation in c:\\Database\\Informix. Read your onconfig file, it will have a ROOTSPACE entry. > I am trying the Server Studio GUI program. Is there an easy way to insert > via a gui? Something akin to SQL Server's Enterprise Manager, where it's > Excel-like with boxes you can fill data with? If I missed in Server Side, > perhaps you can point me out to its functionality. Not that I know of, although there must be some open-source thing that can do that. > Any other good GUIs for Informix? You can try out the ISA (Informix Server Administrator). -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche