Recent

Author Topic: Firebird database safe moving  (Read 915 times)

Saylo_49

  • New Member
  • *
  • Posts: 43
Firebird database safe moving
« on: May 20, 2019, 08:06:09 pm »
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 "

Lazarus 2.0.2 - FPC 3.0.4 - Win32

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1106
Re: Firebird database safe moving
« Reply #1 on: May 20, 2019, 09:20:33 pm »
Hello

I am looking if there is a method for moving safely a firebird database from a machine to another
Yes, 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

  • Hero Member
  • *****
  • Posts: 1131
Re: Firebird database safe moving
« Reply #2 on: May 21, 2019, 08:49:54 am »
You 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.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

 

TinyPortal © 2005-2018