1

Topic: Interbase 2009

Hello. There is a software which by means of DBMS Interbase 2009, continuously writes down the information in a DB (DB-addressee). It is necessary to replace through the period a DB-addressee with an empty DB, thus a software should not interrupt operation. Whether probably such to implement? If yes, I ask to prompt by means of what. In advance many thanks.

2

Re: Interbase 2009

Arbuzzz wrote:

Hello. There is a software which by means of DBMS Interbase 2009, continuously writes down the information in a DB (DB-addressee). It is necessary to replace through the period a DB-addressee with an empty DB, thus a software should not interrupt operation. Whether probably such to implement? If yes, I ask to prompt by means of what. In advance many thanks.

Greetings.
If program modification is not possible, that, , in any way.
Well, and generally, I would write down the data in the foreign table which name would undertake from a certain configuration table.
By change of a name of the exterior table it would be possible to redirect data writing to other foreign table.
The file of the dataful previous exterior table would become accessible to exception.
Yours faithfully, Polesov.

3

Re: Interbase 2009

Look, if I correctly think, the software transfers a DBMS the data which is necessary for writing down in a DB. At some instant the DBMS is disconnected from a DB, thus arriving data, she writes down in the temporary buffer. There is a substitution of a DB and a DBMS  to a new DB. After that the data from the buffer register in a new DB and a data recording proceeds. Here this "temporary " a DB <-> a DBMS really to implement in practice?

4

Re: Interbase 2009

Arbuzzz wrote:

Here this "temporary " a DB <-> a DBMS really to implement in practice?

it is real - write own DBMS and implement a demanded functional.

5

Re: Interbase 2009

Arbuzzz wrote:

It is necessary to replace through the period a DB-addressee with an empty DB, thus a software should not
To interrupt operation. Whether probably such to implement?

It is impossible to implement it. But if you tell what for it it is necessary, is possible
There will be a method. Only do not say that at you on the screw the place stupidly comes to an end.

6

Re: Interbase 2009

From a DB-addressee it is necessary to transfer the data on a communication channel, but because of its low throughput, they  with the big time delays. Reodichesky transmission of a file of a DB on a communication channel eliminates the durable time delays.

7

Re: Interbase 2009

And how it is necessary?

8

Re: Interbase 2009

Arbuzzz wrote:

And how it is necessary?

Do not transfer basis, transfer only the data. FBExport to you in hands.

9

Re: Interbase 2009

Dimitry Sibiryakov;
Could concretize the answer, and hardly more in detail about FBExport. In advance many thanks.

10

Re: Interbase 2009

Arbuzzz wrote:

from a DB-addressee it is necessary to transfer the Data on a communication channel, but because of its low throughput, they  with the big time delays. Reodichesky transmission of a file of a DB on a communication channel eliminates the durable time delays.

For this purpose is nbackup.

11

Re: Interbase 2009

Arbuzzz wrote:

Could concretize the answer

I concretize: preempt the necessary data for transmission to files of any format, pack and
Transfer on the slow channels. Take care, that already transferred data any more
Were preempted at the subsequent sessions. For this purpose, for example, carry out this procedure daily
Also preempt the data "only for yesterday".

12

Re: Interbase 2009

Arbuzzz wrote:

Look, if I correctly think, the software transfers a DBMS the data which is necessary for writing down in a DB. At some instant the DBMS is disconnected from a DB, thus arriving data, she writes down in the temporary buffer. There is a substitution of a DB and a DBMS  to a new DB. After that the data from the buffer register in a new DB and a data recording proceeds. Here this "temporary " a DB <-> a DBMS really to implement in practice?

If to block nbackup' empty basis the DBMS server will write changes to the difference file. Here only I am not assured that stopping service of the server of a DBMS, it is possible to delete the difference file without consequences and the DB will work after restart of the server of a DBMS which creates a new difference file (did not experiment).

13

Re: Interbase 2009

Polesov wrote:

the File of the dataful previous exterior table would become accessible to exception.

the Last time when I such tried something, the old file remained locked process of the server.
As now - I do not know, if to whom not laziness to try, I will tell thanks.

14

Re: Interbase 2009

wrote:

it is necessary to fasten only nbackup to Interbase...

There there is the nbackup, since  2007.
gbak-d
https://www.ibase.ru/ib2007updateguide/

15

Re: Interbase 2009

wrote:

12/21/2017 14:52, rdb_dev writes:
> If to block nbackup' empty basis...
It is necessary to fasten only nbackup to Interbase...

:-D Or to migrate on FirebirdSQL.
When the answer wrote, at all did not recall that speech about Interbase. Got used that, normally, we consider FirebirdSQL.

16

Re: Interbase 2009

rdb_dev wrote:

When the answer wrote, at all did not recall that speech about Interbase. Got used that, normally, we consider FirebirdSQL.

Well it is finite, and council about nbackup was good? Bosh any. If he wants to replace basis on empty how nbackup here helps?
If there are the active connections to a DB, it is impossible to "change" a DB file in any way, . , the Holy Spirit.
And to hold delta all time, and it somehow to "delete" is, excuse, generally  what good advice.
Without a stop of the server or switch-off of all connections - yes, neither basis, nor delta, line, it is impossible to change.

17

Re: Interbase 2009

kdv, what for to replace with the empty? Empty , and the difference file to transfer.

18

Re: Interbase 2009

kdv wrote:

Without a stop of the server or switch-off of all connections - yes, neither basis, nor delta, line, it is impossible to change.

I and wrote that the server should be stopped.

19

Re: Interbase 2009

rdb_dev;
Then what for  with deltas? To take away "the filled" basis, on its place to put the empty.

20

Re: Interbase 2009

WildSery, to me , the delta will be a little less - for the size of meta data.

21

Re: Interbase 2009

rdb_dev wrote:

kdv, what for to replace with the empty? Empty , and the difference file to transfer.

It is nonsenses.
And here to do an increment and to transfer it is another matter.
On the receiver - to recover a DB.
In 4-ke all for this purpose is.

22

Re: Interbase 2009

hvlad wrote:

And here to do an increment and to transfer it is another matter.
On the receiver - to recover a DB.
In 4-ke all for this purpose is.

I Think, incremental  - that is necessary ', only he yet did not understand. smile

23

Re: Interbase 2009

rdb_dev wrote:

kdv, what for to replace with the empty? Empty , and the difference file to transfer.

In delta IB exists only at the moment of performance gbak-d. It  in  basis is possible , and then .
"The difference file to transfer" -  full. To transfer where, what for, and what with it to do there where transferred? Same the intermediate file, anchored guid th to specific basis.

rdb_dev wrote:

WildSery, me , the delta will be a little less - for the size of meta data.

My God, would be to save on what.

rdb_dev wrote:

I Think, incremental  - that is necessary ', only he yet did not understand.

At it InterBase 2009. There incremental  on another becomes. Suffices already a hogwash .

24

Re: Interbase 2009

rdb_dev wrote:

I Think, incremental  - that is necessary ', only he yet did not understand. smile

Not the fact. It is not known that at it with basis becomes on a receiving party.

25

Re: Interbase 2009

WildSery wrote:

it is passed...
The last time when I such tried something, an old file remained locked process of the server.
As now - I do not know, if to whom not laziness to try, I will tell thanks.

Tried on FB2.5.7 - at exclusive access right after  the file of the exterior table is released.
As in IB2009 - I do not know.