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