Rebuild-Firebird

Rebuild a Firebird database using stream conversion (without intermediate files).

Can also be used to migrate a database between different On-Disk-Structure versions.

Based on Fast conversion of Firebird 2.5 databases to Firebird 3.0 article from Basil Sidorov.

Requires a 64-bit Windows.

How to install

To download all scripts into your $env:temp folder:

iex (iwr 'https://raw.githubusercontent.com/fdcastel/Rebuild-Firebird/master/bootstrap.ps1' -UseBasicParsing)

All necessary files are included or downloaded. You don't need an installation of Firebird Server.

Usage

Rebuild-Firebird.ps1 [-SourceFile] <string> [[-User] <string>] [[-Password] <string>] [[-TargetFile] <string>] [-WhatIf] [-Confirm] [<CommonParameters>]

Inform the source database through -SourceFile parameter. The ODS version will be detected automatically.

The target database will have the same name as source plus the suffix .CERT. You may use -TargetFile to change this.

Convert database to a different ODS

Rebuild-Firebird.ps1 [-SourceFile] <string> [[-WithVersion] <string>] [[-User] <string>] [[-Password] <string>] [-WhatIf] [-Confirm] [<CommonParameters>]
Rebuild-Firebird.ps1 [-SourceFile] <string> [[-WithVersion] <string>] [[-User] <string>] [[-Password] <string>] [[-TargetFile] <string>] [-WhatIf] [-Confirm] [<CommonParameters>]

Use the -WithVersion parameter to choose the target Firebird version.

The target database will have the same name as source plus the target version added as suffix. You may use -TargetFile to change this.

Common parameters:

• -User: Firebird username. Default = SYSDBA.
• -Password: Firebird password. Default = masterkey.
• -WhatIf: Display the operations without actually execute them.