Oninit cdi / Archive
Talk to an expert →

AW: Restore on different version

Posted in 2006

Topics: Migration, Import/Export & Data Conversion, Platform-Specific Issues, Internationalization & Character Sets

Model-Bosch, Tilman — — source: Usenet: comp.databases.informix

> Correction: > > Adding to Martin's comment, My opinion is a Database restore > of IDS irrespective of version should > not work if your Source Database is in HP UX and you are > restoring in Sun Solaris as IDS software is > again OS specific. > > Thanks, Actually restoring a backup from the same IDS version on different OS platforms is unsupported. Depending on byte order and page size it still may work. ! When your database(s) use OS locales you might run into troubles after the restore, when locales on the OS are different. The restore may work but the data may still be inaccessible. However, I know of customers who did successfully restore RELIANT backups to SOLARIS instances. Nevertheless, I don't recommend it (unless you are desperate). Rather follow a supporetd migration path for a change of the OS. Keep in mind that IBM Informix Support will not be able to help you on any troubles in such a case. Best regards Tilman

↪ replying to Model-Bosch, Tilman
Madison Pruet — — source: Usenet: comp.databases.informix

Model-Bosch, Tilman wrote: >> Correction: >> >> Adding to Martin's comment, My opinion is a Database restore >> of IDS irrespective of version should >> not work if your Source Database is in HP UX and you are >> restoring in Sun Solaris as IDS software is >> again OS specific. >> >> Thanks, > > Actually restoring a backup from the same IDS version on different OS > platforms is unsupported. > Depending on byte order and page size it still may work. I call this 'voodoo computing'. It requires a witch-doctor to make it work. Sometimes it works. Sometimes it doesn't. We generally don't want to suggest solutions to the customers that require magic and the aid of witch-doctors to be successful. ;-) M.P. > ! When your database(s) use OS locales you might run into troubles > after the restore, when locales on the OS are different. > The restore may work but the data may still be inaccessible. > > However, I know of customers who did successfully restore RELIANT > backups to > SOLARIS instances. > > Nevertheless, I don't recommend it (unless you are desperate). Rather > follow a supporetd migration path for a change of the OS. > > Keep in mind that IBM Informix Support will not be able to help you on > any troubles in such a case. > > Best regards > Tilman

Glossary