Re: Ontape platform compatability ?

Lello, Nick wrote: > I was hoping that they'd done some magic :-) > > Oh well, back to good ol' myexport > > -----Original Message----- > From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] > Sent: 07 January 2010 11:03 > To: Lello, Nick > Cc: informix-list@iiug.org > Subject: Re: Ontape platform compatability ? > > Lello, Nick wrote: >> All, >> >> Does anyone know if the ontape platform-dependancy was removed in or >> prior to 11.50.* >> >> ie: can I restore a level0 archive from a Solaris Sparc system onto an >> Linux Intel system or do I still need to export/import ? > > It has not been removed, and without massive surgery, I can't see how it > > will ever be removed. You could always log a feature request with Tech Support to ask for a platform-independent backup. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

On 7 Jan, 13:03, Obnoxio The Clown <obno...@serendipita.com> wrote: > Lello, Nick wrote: > > I was hoping that they'd done some magic :-) > > > Oh well, back to good ol' myexport > > > -----Original Message----- > > From: Obnoxio The Clown [mailto:obno...@serendipita.com] > > Sent: 07 January 2010 11:03 > > To: Lello, Nick > > Cc: informix-l...@iiug.org > > Subject: Re: Ontape platform compatability ? > > > Lello, Nick wrote: > >> All, > > >> Does anyone know if the ontape platform-dependancy was removed in or > >> prior to 11.50.* > > >> ie: can I restore a level0 archive from a Solaris Sparc system onto an > >> Linux Intel system or do I still need to export/import ? > > > It has not been removed, and without massive surgery, I can't see how it > > > will ever be removed. > > You could always log a feature request with Tech Support to ask for a > platform-independent backup. > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. The best we have now is archecker that can insert table data from a backup into a table in a platform independent manner. If you know the schema for the system catalog of that version you could produce a tool that: 1. Extracted the system catalog data into a set of dummy catalog tables using archecker 2. Used the system catalog data to create empty tables 3. Extracted the table data into the empty tables 4. Used the system catalog data to create the rest of the database schema (indexes,contraints,views,synonyms,grants,revokes,sequences etc). It would work but would be very slow (although the tables can be processed in parallel for loading data and index creation). Steps 2 and 4 can be worked out using the manuals and some tweaking from real testing (I found some undocumented values that were not in the manual the IBM had to explain!). Just make sure the code errors out if it finds ANYTHING it does not understand. [ I am surprised Art has not written something for this,archecker has been around for a while!].