Subject RE: [firebird-support] replace a database in production
Author Svein Erling Tysvær
>>i have a web app that use firebird embedded database hosted in the internet.
>>and the same database in local used by a regular database 2.5 server
>>I have to replace the web database with the local one (a kind of replication)
>>the problem is that the database could be used at that moment so locked at that time,therefore impossible
>>to replace the fdb file.
>>so any idea and suggestions on how this could be done is welcome
>This is simple,
>Change your web app to check some config. I do not know what technology you use. But in e.g..Net is file >web.config. store there value like disableonnections=true and check this config value in your web app. If value is true >report back to the user that some administrative work is in progress
>This is prefered design

Being that he wants to replace the database, I take it that the database is primarily for reading. Then, an alternative to the 'administrative work message', would be to copy the database to a different file name and then just change the config file to point to the new database. Thus, stuff reading the config file before the change was made would continue to work against the old database, whereas new would go against the new copy.