| Subject | Re: [firebird-support] Re: Max Transaction ID - Email found in subject |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2011-02-15T15:46:55Z |
On 2/15/2011 12:45 AM, Kjell Rilbe wrote:
from gbak, all the records have different record numbers, and are
stored on on different pages. The indexes have been recreated, etc.
So, assuming that every table has a primary key, you could take the
data pages (which are identified by table), decompress the records,
and compare them to the new database by primary key to determine
which were inserted or updated. Figuring out which were deleted
would be harder (than I can imagine).
Using triggers to create a log that could be replayed on the new
database would be much simpler.
Cheers,
Ann
>Beating a dead horse here, but after you've done a backup and restore
> Yes, but it should be possible for a specially written tool to interpret
> the diff file's pages into data rows, index pages, etc. and based on
> that make updates to the database restored with gbak.
from gbak, all the records have different record numbers, and are
stored on on different pages. The indexes have been recreated, etc.
So, assuming that every table has a primary key, you could take the
data pages (which are identified by table), decompress the records,
and compare them to the new database by primary key to determine
which were inserted or updated. Figuring out which were deleted
would be harder (than I can imagine).
Using triggers to create a log that could be replayed on the new
database would be much simpler.
Cheers,
Ann