We have migrated our legacy historian several times using saveh50 and loadh50. It actually works pretty well.
The saveh50 utility unloads the Informix data and table structure to a series of sql scripts and files of ascii data. There is not a lot of interaction once the process starts. It takes quite a bit of time (hours) to unload the database depending on the machine and the amount of data. Be patient while it runs. Before running the loadh50 make sure you have allocated enough space to the informix raw partition. If I remember correctly the default is only 50 Meg. There is a helpful hint HH528 on expanding the raw partition and checking the size of your current partition. Gerry Ries City of San Francisco Water Pollution Control Division 750 Phelps St San Francisco CA 94124 Phone: 415.648.6882 ext. 1256 Fax: 415.648.8420 -----Original Message----- From: Bertollini, Paride [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 5:54 AM To: Foxboro DCS Mail List (E-mail) Subject: Legacy Historian Upgrade Hi, Is anyone of you already experienced with an upgrade of a Legacy historian? Customer needs to make larger his historian, from 500 to 1000 points without loosing his preexisting configuration. Do the saveh50 and loadh50 utilities allow this? Step by step: -saveh50 -recommit with new historian size(same name) -loadh50 is this possible or is it enough?I've looked on Helpful hints, CARS, but i've not found documents about this. Thank you in advance. Paride Bertollini Invensys Foxboro Italia Customer Service Dept. mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------- This list is neither sponsored nor endorsed by the Foxboro Company. All postings from this list are the work of list subscribers and no warranty is made or implied as to the accuracy of any information disseminated through this medium. By subscribing to this list you agree to hold the list sponsor(s) blameless for any and all mishaps which might occur due to your application of information received from this mailing list. To be removed from this list, send mail to [EMAIL PROTECTED] with "unsubscribe foxboro" in the Subject. Or, send any mail to [EMAIL PROTECTED] ----------------------------------------------------------------------- This list is neither sponsored nor endorsed by the Foxboro Company. All postings from this list are the work of list subscribers and no warranty is made or implied as to the accuracy of any information disseminated through this medium. By subscribing to this list you agree to hold the list sponsor(s) blameless for any and all mishaps which might occur due to your application of information received from this mailing list. To be removed from this list, send mail to [EMAIL PROTECTED] with "unsubscribe foxboro" in the Subject. Or, send any mail to [EMAIL PROTECTED]