Re: Backup IB 2007 Restore IB 6

Peter Batten wrote:
> Is it possible to backup an IB 2007 file and restore to IB 6 format?

Highly unlikely. Simply extract metadata, use that script to create a db 
on a machine with IB 6 installed, then use IBDataPump (or other such 
utility) to move data across. That is the only safe way.

Peter Batten wrote:

> Is it possible to backup an IB 2007 file and restore to IB 6 format?
> 
> I have tried with several different IBConsole versions but run into a
> 'String Truncated' error when rebuilding generators.  It stops at
> different generators on each restore attempt but in the same general
> area.
> 

The problem might be that some of your metadata names are to long. In
IB6 they are restricted to 39 characters. Features not supported in IB6
like case etc. will also make the downgrade impossible.
-- 
Gelein van de Voorde (IBConsole team)

"The blossoms on an apple tree are standardized,
and yet they are all different.
That is how we, too, should learn to build."

Is it possible to backup an IB 2007 file and restore to IB 6 format?

I have tried with several different IBConsole versions but run into a
'String Truncated' error when rebuilding generators.  It stops at different
generators on each restore attempt but in the same general area.

TIA

Peter

> IB6 they are restricted to 39 characters. Features not supported in IB6

31 characters.


-- 
Martijn Tonies
Database Workbench - the IBConsole alternative!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com