Subject RE: [firebird-support] Wanting to shift from firebird 1.0.3 on redhat to 2.1.2 on windows server 2008
Author Leyne, Sean
> We have an application here at work that was written in the mid to late
> 90's that has a database server that is running on firebird 1.0.3 on
> redhat. The database has the borland extension (.gdb) and all the
> automated backup files have a .bak extension.
>
> I am trying to copy and transfer the database to firebird 2.1.2 on windows
> server 2008.

Unless you are the database developer, don't do that.

It would be a "fluke" to take a 1.0.3 database and migrate it to 2.1 via backup/restore.

The option you should follow is to:

1 - Install FB v1.0.3 on the Win2008 server

2 - copy the database file from RedHat to Win2008 (make sure that the IBServer is not running on RedHat)


Upgrading the database schema to the latest version requires a reasonable knowledge of the application and of Firebird (and the syntax changes introduced since v1.0.3).


Sean