kafor.blogg.se

Firebird supports application programs and triggers, as well as many ANSI SQL standard features. Firebird is written in C and C++ and works on a variety of hardware and software components, including Windows, Linux, and Mac OS X. We also tried to import this dumpfile to an linux server running Firebird 1.5.4, there import works fine, unfortunatly we are in need of using this solaris server.Firebird is a free, fully accessible SQL relational database management system based on Borland Software Corp’s (previously known as Inprise Corp) open source edition of InterBase. On Solaris when I execute this command I get errorĭescription: We want to migrate from Windows-Firebird Database (1.5.2) to Solaris-Firebird (1.5.2) On Windows instalation it's works fine, database restore and running Gbak -USER sysdba -PASS masterkey -C backup.fbk database.fdb

Is there something i have to install in Firebird-Server installation-dir, or in Solaris-OS? What do i have to do, so Firebird Server ISO8859_1 is working on Solaris 8?

> if using another character set, it's working fine: SQL> CREATE TABLE ENTRYVECTOR2 (NAME BCTYP NOT NULL) * Definition for the `BCTYP` domain : */ It seems as if there is some characterset issue:

In the meantime we got a clue what's happing: We also tried to import this dumpfile to an linux server running Firebird 1.5.4, there import works fine, unfortunatly we are in need of using this solaris server. SOLARIS-SERVER> gbak -v -backup -transportable -user SYSDBA -password xxxx WINDOWSSERVER:c:\\TECAN\\DATA\.GDB test We also tried to do an remote backup and local import, so we can exclude an transfer error while using ftp. Gbak: Exiting before completion due to errors Gbak: ERROR: unsuccessful metadata update Gbak: restoring generator CLEANUPID value: 52 Gbak: restoring generator PLATEID value: 1797 SOLARIS-SERVER> gbak -c -v -user SYSDBA -password masterkey tecanexport /export/home/firebird/tecan-db/tecan.fdb We transfered this export via ftp in binary mode to sun Solaris. WINDOWS-SERVER> gbak -v -backup -transportable -user SYSDBA -password xxxxx c:\TECAN\\DATA.GDB tecanexport So we made a transportable backup on this windows machine: (executed gbak on windows server, directly) We want to migrate from Windows-Firebird Database (1.5.2) to Solaris-Firebird (1.5.2)