Provide a way to rename or copy database file
---------------------------------------------
Key: CORE-4053
URL: http://tracker.firebirdsql.org/browse/CORE-4053
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: michalk1
The recommended way to restore a database file is to restore it under temporary
filename, and only when it's succesfully created, replace the original database
file. However, the engine currently doesn't offer any support for this action
(file rename or copy operation), that could be controlled from an application
running at a remote client station. Such a feature would simplify database
restoration process and other database actions, that must be executed on a
database copy.
Studying archives, I found several workarounds, none of them being perfect:
- Write a udf library with that functionality - requires every developer to
maintain and install several versions of such a library (Win/Linux,
32bit/64bit, ...). Customers can't run Firebird out of the box. Such a udfs may
be also prone to errors, because developers may not be aware of FB file locking
etc.
- Server-side backup and restore (through services API) of the database to
"rename" it - works, but is slow and requires fallback plan (in case of a power
failure during restore process etc.).
- Server-side backup and restore by the new nbackup services API in FB2.5. Much
faster than gbak, but still not as fast as a simple file rename or copy.
Furthermore, nbackup doesn't allow to overwrite the intermediary nbk file.
Every run must be executed with a different temporary filename, which causes
the nbk files to pile up, and there is no way to delete them from the client
station.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
