Re: [firebird-support] Backup Firebird 3.0.2 database using Service Manager

2017-10-09 Thread pierr...@gmail.com [firebird-support]
Will you believe me I I tell you I Read Quite Every Fucking [Manual/ReleaseNotes/ReadmeInDocFolder/Code] before asking ? I already clicked the "Send" button while I remembered having read that line some minutes ago :

[firebird-support] Re: Backup Firebird 3.0.2 database using Service Manager

2017-10-09 Thread pierr...@gmail.com [firebird-support]
Got it ! Both my fbsvcmgr command and TUIBBackup miss the new "isc_spb_expected_db" spb in isc_service_attach() C:\>fbsvcmgr localhost:service_mgr -user DBOWNER -password ownerpasswd -expected_db config -action_backup -dbname config -bkp_file c:\programdata\prycorp\temp\config.fbk

Re: [firebird-support] Backup Firebird 3.0.2 database using Service Manager

2017-10-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.10.2017 16:08, pierr...@gmail.com [firebird-support] wrote: > If I try to use a remote connection to service_mgr RTFM -expected_db. -- WBR, SD.

[firebird-support] Backup Firebird 3.0.2 database using Service Manager

2017-10-09 Thread pierr...@gmail.com [firebird-support]
Hi there, I'm desperately trying to backup a Firebird 3.0.2 database using UIB TUIBackup. My database is configured as this in databases.conf # security.db = $(dir_secDb)/security3.fdb # { # RemoteAccess = false # DefaultDbCachePages = 50 # } # # My Databases # config =

RE: Re[2]: {Disarmed} [firebird-support] Using FB2.5 with NFS for Virtualbox VM

2017-10-09 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
<> Simply put. As long as the database on the NFS mount cannot be accessed by another Firebird server on another system then you can use this "feature" (RemoteFileOpenAbility). Regards Paul

Re: [firebird-support] detect if database has changed

2017-10-09 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi, You can also look at sample at http://itstop.pl/pl-pl/porady/Firebird/FAQ1/czas-ostatniej-modyfikacji-tabeli It is in PL lang but triggers are fully descriptive. I prefer generator based approach Regards,Karol Bieniaszewski null

Re: [firebird-support] select column if it exists

2017-10-09 Thread Elmar Haneke el...@haneke.de [firebird-support]
> Is there a way to include a column in a SELECT but substitute a value if > it doesn't? I need my code to work with different versions of my db schema. > > eg I want to SELECT A, B, C, ... but C might not exist. > > SELECT * would work of course, except it will fetch a bunch of columns I >

Re: [firebird-support] detect if database has changed

2017-10-09 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Look at System Audit feature. Regards, Alexey Kovyazin IBSurgeon HQbird www.ib-aid.com On 09.10.2017 2:49, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: Is there an official way to detect if a database has changed? I have some expensive reports and backups to run,