Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Had somewhat the same concern as @frofa - need to migrate some existing data for testing. Entering data manually was out of the question. Months ago tried copy/paste method for tables. This had a problem with dates. Recently (see comment) tried again but this time problem with numeric/decimal data (Bug report filed). Have tried other methods including writing macros but problem persisted.

Have now come up with a solution which may not be likable to most users. It involves using Firebird 3 Server. The process was performed in Linux Mint 18.3 with LO v.6.0.2 & v6.1dev:

  • Installed Firebird 3 Server.
  • Created DB
  • Created Base file connected to server DB
  • copied tables (copy & paste) from MySQL Base file
  • created a View in Firebird Base file
  • Used FlameRobin DB Admin tool to create backup of Firebird DB just filled with copied tables. This created a "xxx.fbk" file.
  • Renamed this to "firebird.fbk"
  • Using a created Base file (LO v6.0.2) with embedded Firebird, replaced "firebird.fbk" in "/database" folder with newly created one.

Opened the embedded Firebird Base file (tried both v6.0.2 and recent 6.1dev) and all tables & view were present. Was able to add, modify and delete records. This is certainly the very earliest stage of testing but promising nonetheless.

Basic stats:

17 tables; 1 view; over 6500 records total with largest table containing just over 2000 records & smallest was 3 records.

Another concern may be SQL. Over the past month have done some testing & some modifications may be needed in existing code. My existing statements needed quite a few changes. The Firebird 2.5 Language Reference is a big help ->Firebird Documentation. This seems to be the latest version.

Hope this helps some.

Had somewhat the same concern as @frofa - need to migrate some existing data for testing. Entering data manually was out of the question. Months ago tried copy/paste method for tables. This had a problem with dates. Recently (see comment) tried again but this time problem with numeric/decimal data (Bug report filed). Have tried other methods including writing macros but problem persisted.

Have now come up with a solution which may not be likable to most users. It involves using Firebird 3 Server. It is for tables & views only. The rest seems to work with copy/paste from one Base file to another. The process was performed in Linux Mint 18.3 with LO v.6.0.2 & v6.1dev:

  • Installed Firebird 3 Server.
  • Created DB
  • Created Base file connected to server DB
  • copied tables (copy & paste) from MySQL Base file
  • created a View in Firebird Base file
  • Used FlameRobin DB Admin tool to create backup of Firebird DB just filled with copied tables. This created a "xxx.fbk" file.
  • Renamed this to "firebird.fbk"
  • Using a created Base file (LO v6.0.2) with embedded Firebird, replaced "firebird.fbk" in "/database" folder with newly created one.

Opened the embedded Firebird Base file (tried both v6.0.2 and recent 6.1dev) and all tables & view were present. Was able to add, modify and delete records. This is certainly the very earliest stage of testing but promising nonetheless.

Basic stats:

17 tables; 1 view; over 6500 records total with largest table containing just over 2000 records & smallest was 3 records.

Another concern may be SQL. Over the past month have done some testing & some modifications may be needed in existing code. My existing statements needed quite a few changes. The Firebird 2.5 Language Reference is a big help ->Firebird Documentation. This seems to be the latest version.

Hope this helps some.

Had somewhat the same concern as @frofa - need to migrate some existing data for testing. Entering data manually was out of the question. Months ago tried copy/paste method for tables. This had a problem with dates. Recently (see comment) tried again but this time problem with numeric/decimal data (Bug report filed). Have tried other methods including writing macros but problem persisted.

Have now come up with a solution which may not be likable to most users. It involves using Firebird 3 Server. It is for tables & views only. The rest seems to work with copy/paste from one Base file to another. The process was performed in Linux Mint 18.3 with LO v.6.0.2 & v6.1dev:

  • Installed Firebird 3 Server.
  • Created DB
  • Created Base file connected to server DB
  • copied tables (copy & paste) from MySQL Base file
  • created a View in Firebird Base file
  • Remove all table relationships
  • Used FlameRobin DB Admin tool to create backup of Firebird DB just filled with copied tables. This created a "xxx.fbk" file.
  • Renamed this to "firebird.fbk"
  • Using a created Base file (LO v6.0.2) with embedded Firebird, replaced "firebird.fbk" in "/database" folder with newly created one.
  • Can now re-apply table relationships

Opened the embedded Firebird Base file (tried both v6.0.2 and recent 6.1dev) and all tables & view were present. Was able to add, modify and delete records. This is certainly the very earliest stage of testing but promising nonetheless.

Basic stats:

17 tables; 1 view; over 6500 records total with largest table containing just over 2000 records & smallest was 3 records.

Edited 2018-05-11:

Added steps in above process to remove/replace table relationships. These do not transfer properly & will cause the Firebird embedded to hang if you attempt any relationships. By deleting prior to backup and creating anew in the embedded, all seems OK. No hanging of Base.

Another concern may be SQL. Over the past month have done some testing & some modifications may be needed in existing code. My existing statements needed quite a few changes. The Firebird 2.5 Language Reference is a big help ->Firebird Documentation. This seems to be the latest version.

Hope this helps some.