Great - thanks Mark. I only need FR just for that, simple queries and the occasional update/delete sql.
> On Apr 30, 2020, at 9:09 AM, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] <firebird-support@yahoogroups.com> wrote: > > On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com > <mailto:kevin.stan...@rdb-solutions.com> > [firebird-support] wrote: > > I always tend to do back / restores not only in this migration but on > > a regular basis. I’m maybe a little on the paranoid side. :) > > I have noticed some extra lines in the restore log for FB3 (this is > > true even on a completely new FB3 database): > > > > gbak:fixing views dbkey length > > gbak:updating ownership of packages, procedures and tables > > gbak:adding missing privileges > > gbak:fixing system generators > > gbak:finishing, closing, and going home > > gbak:adjusting the ONLINE and FORCED WRITES flags > > > > Those are just steps that gbak will apply, even if there is 'nothing to > fix'. > > > > > The script is very easily generated out of IB Expert. I cannot praise > > this tool enough. > > > > I haven’t tried the script using isql but I would be surprised if it > > didn’t work. I will give it a shot possibly over this coming weekend. > > I’m slammed at the moment. > > > > I also use FlameRobin for FB1. Not sure if that is compatible with > > FB3? There were some concerns in previous postings. > > FlameRobin works with Firebird 3, but it doesn't support the new boolean > datatype, and it has no support for packages and PSQL function, which > might incorrectly show procedures from packages, or functions. In > addition, user management should now be done through SQL, so the user > management options in FlameRobin will still work, but they will only > work with the first (default) UserManager. There might be some more > issues, but for general query work it will work fine. > > Mark > > [Non-text portions of this message have been removed]