| Subject | RE: [firebird-support] Database Forensics |
|---|---|
| Author | Edward Mendez |
| Post date | 2014-07-10T18:27:45Z |
Thank you for the response.
At the moment will need to open the Database and view the data contents and DDL of the objects and compare it to another database. The Database file we will be receiving should not be corrupt, but I don’t want to rule out that possibility. I will add IBSurgeon FirstAID to my list.
Thank you.
-Ed M.
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, July 10, 2014 1:34 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Database Forensics
On 9-7-2014 21:34, 'Edward Mendez' Emendez001@...
[firebird-support] wrote:
> I have a situation where I might have to open up a FIREBIRD DatabaseYes, a Firebird 2.5 can open database from Firebird 2.1. Upgrading the
> file that I didn’t create or maintain. I probably will not know the
> exact version of FIREBIRD this file was used with. It can be anything
> from FIREBIRD 2.1.4 up to 2.5.2
>
> The database file will be given to me on a read only external HD. It
> will be accessed from a windows 7 PC. Everything I will need must
> already be preinstalled on this PC before taking possession of this
> Database File. (i.e. this PC will not be connected to the internet in
> order to install new software.) I can have an installer reside on a
> folder for install if I need it.
> One question I have was that if I install a FB 2.5.2 Server on this
> windows PC would I be able to open a Database that has been created
> using a 2.1.4 server?
database by backup and restore is a best practice (it upgrades the ODS
so new features are available), but it is not strictly necessary. With
Firebird 3 this is going to change!
> Are there any programs out there that can open up a Firebird DB locallyAt a minimum you will need a program that uses Firebird embedded.
> without a server/embedded installed?
> My plan was to…That sounds like the wisest course of action.
>
> 1)Keep a copy of the msi installers for Firebird server 2.1.4/5 & 2.52
> somewhere on the Disk of this PC.
> 2)Install a copy of IBEXPERT free edition on the PC to view the data/schemaCan't think of anything else right now.
>
> 3)Install FBExport & FBCopy in case I need to export the data into
> another format.
>
> Is there something I might have missed or something that will work
> better than what I plan to use.
However, the big question is: what is it you need to do with the
database? If the database is damaged and the needs to be repaired, then
Firebird will not be able to (correctly) read the file, and you'd sooner
need something like IBSurgeon FirstAID (assuming simple fixes with gfix
won't work).
Mark
--
Mark Rotteveel