RE: Question about export/inport

That is exactly what High-availability Data Replication (HDR) was made for!! RTFineM about it, in the System Admin Guide. HDR works great for this, with very little admin effort. If you don't have a hard-copy of the manual, check out http://www.informix.com/answers. If you have questions after you read up on it, let me know and I'll try to help out... HTH, Paul Mosser -----Original Message----- From: dfilip@colornet.com [mailto:dfilip@colornet.com] Sent: Thursday, August 31, 2000 3:11 PM To: informix-list@iiug.org Subject: Question about export/inport Greetings, Although this is probably a simple question, I'm not sure start and am looking for pointers. Although my experience is mostly with Oracle, I am working at a client who has an Informix database (7.3). I am helping them add redundancy and fail-over. The database is small (<50 MB) and reasonably static (some changes every day, although through administrative changes, not user initiated). What I want to do is periodically (perhaps nightly, or maybe several times during the day) export the contents of the "master" database, and restore that database on a "backup" database. The intent is that if the master database ever crashes, we can easily point the application to use the backup database. My question is how do I export / import on Informix 7.3 IDS? Would I use some syntax of the onbar, which looks like it wants to write to tape? Or is there some other utility that I should be looking at? Sorry for the newbie question, but I haven't had much experience with Informix, and am looking for the right place to start. With Oracle, I have written scripts that export / FTP / import automatically, when faced with similar environments. Thanks, Dave. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- = = David E. Filip | Email: dfilip@colornet.com = = ColorNet Information Systems | WWW : http://www.colornet.com = =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =