Firebird database safe moving
lazarus / 16-Databases

----------------------------------------------------------------------
Saylo_49 · 2019-05-20 18:06

Hello

I am looking if there is a method for moving safely a firebird
database from a machine to another

" Why moving a database ?
I am working on a software project with a specific file extension
This file extension is a zip file that contain the database file
created for the user and bundled with others files in one zipped file
and the user can share this file with others users of the same
software
It is supposed to work as document file
The username and password of the database are defined and loaded
internally by the software but the software can give the ability to
the user to his own logins as an advanced security "

----------------------------------------------------------------------
valdir.marcos · 2019-05-20 19:20

Quote from: Saylo_49 on May 20, 2019, 08:06:09 pmHello

I am looking if there is a method for moving safely a firebird
database from a machine to anotherYes, do backup and restore:
https://firebirdsql.org/manual/gbak-cmdline.html
https://firebirdsql.org/manual/gbak-recipies.html

You may also simply try (not recommended):
Close all connections to Firebird database file and simply copy it
from on disk to another.

For advanced admins:
Do replication.
https://www.geeksforgeeks.org/dbms-data-replication/

Quote"Why moving a database ?
I am working on a software project with a specific file extension
This file extension is a zip file that contain the database file
created for the user and bundled with others files in one zipped file
and the user can share this file with others users of the same
software
It is supposed to work as document file
The username and password of the database are defined and loaded
internally by the software but the software can give the ability to
the user to his own logins as an advanced security"

----------------------------------------------------------------------
mangakissa · 2019-05-21 06:49

Quote from: valdir.marcos on May 20, 2019, 09:20:33 pmYou may also
simply try (not recommended):
Close all connections to Firebird database file and simply copy it
from on disk to another.
It depends. I'm moving Embedded firebird file directly to another
directory / pc. 2 years now without any problems.
If server related, make a backup and restore.