Ask Your Question
0

RazorSQL and Embedded Firebird

asked 2020-04-04 02:58:08 +0200

bbater gravatar image

I am looking to back-up a Base database other than just copying the ODB file. Other SQL RDBMSs I've used in the past were able to export both structure and data to a '.sql' text file which could be used to restored the database if needed. I found a web site which advised using the SQL "SCRIPT 'file.sql'" in the SQL window of Base but this generates an error. I have downloaded a trial version of RazorSQL which can apparently do the job but I am dubious that it can handle an embedded Firebird server as with Base. Does anyone have any information on this topic?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2020-04-05 08:27:47 +0200

m.a.riosv gravatar image

For Firebird there is a breve explanation Firebird FAQ on how to with an ISQL -a command option, but it needs Firebird server installed. Like it's mentioned in the Faq can be done with FlameRobin a very light database administrator for Firebird.

edit flag offensive delete link more

Comments

@m.a.riosv,

I do not see any method from ISQL or FlameRobin to gain access to the embedded Firebird database. Seems each would require this to be a server registered DB.

Could you provide some insight to this?

Ratslinger gravatar imageRatslinger ( 2020-04-05 16:23:26 +0200 )edit

Surely I was not clear in my answer, you require the Firebird server installed and running it from a command line.

m.a.riosv gravatar imagem.a.riosv ( 2020-04-05 17:28:44 +0200 )edit

Sorry having server installed was clear. What is not clear is how, even from the command line, ISQL is able to access the embedded Firebird database.

Have never been able to do this. And FlameRobin certainly requires the DB to be registered.

That is, unless you are actually stating to use the server instead of the embedded file.

Ratslinger gravatar imageRatslinger ( 2020-04-05 17:40:19 +0200 )edit

Your right, but copying/extracting the database file from the odb file to a system folder, I think can be done and automated with batch on the OS, or maybe calling the batch or the commands from a macro.

m.a.riosv gravatar imagem.a.riosv ( 2020-04-05 17:51:35 +0200 )edit

Thank you for responses. Yes, can envision that method as have already used similar in transferring DB's from server to embedded. Just was hoping for a simpler method such as what RazorSQL seem to perform.

Ratslinger gravatar imageRatslinger ( 2020-04-05 19:12:59 +0200 )edit

Thanks m.a.riosv and Ratslinger, between you you've answered my question.

bbater gravatar imagebbater ( 2020-04-06 00:48:48 +0200 )edit
0

answered 2020-04-04 03:49:08 +0200

Ratslinger gravatar image

Hello,

Please see answer in his post regarding RazorSQL -> generate sql table dump from Base

Personally don't have any experience with this product.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-04-04 02:58:08 +0200

Seen: 52 times

Last updated: Apr 05