Thanks Ann,. I will try that also.

What I can say what we have somehow decided to do is to take a standard
IB 5.6 database. Update it to the structure of the IB 7.5 database and then
Then backup and restore to FB and then
Pump all the data over from the 7.5 database to the FB.

WE have tried this and it works. Does take some time, But I must admit I
feel better doing it , as I then know that ALL data written by the database
was done via FB and not IB

Thanks for all your help and have a nice day

Johannes

At 17:11 28/06/2006, you wrote:

>Johannes Pretorius wrote:
>>
>> gbak: ERROR: arithmetic exception, numeric overflow, or string truncation
>> gbak: Exiting before completion due to errors
>>
>Firebird and InterBase have had six years of independent development
>with programmers who have different goals. The Firebird developers
>are more rigorous about detecting potential errors.
>
> > I then just for fun tried to remotely backup from the FB Server with
> > the Fb's gbak program the database on the IB machine , this ran well
> > but gave the same error on a different SP.
>
>That's the right procedure, generally, but I would start by using ISQL
>to extract the system metadata from the database - using InterBase's
>ISQL. Then I'd drop all the procedures using InterBase's ISQL again.
>Then I'd use Firebird's backup/restore to create a Firebird database.
>If that works, I'd try recreating the procedures from the extracted ddl
>script.
>
>Regards,
>
>
>Ann
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 26/06/2006

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.6/378 - Release Date: 28/06/2006