dbMigration .NET 2.5 released

dbMigration .NET is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data between different databases without complicated procedures.

Supported databases: Firebird 1.5~3.0, PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, SQLite, SQLCe, Access, dBase, FoxPro, Excel, ODBC, OLEDB…etc.

New features and improvements from 2.3 to 2.5 (2016/02/10)

For more information please visit http://fishcodelib.com/DBMigration.htm
Free, All-In-One, Portable, and Single executable file.

Database .NET 17.5 released

Database .NET is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data, Run queries and Migrate data with a consistent interface. (Full support for Firebird 1.5~3.0)

For more information please visit http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multi-language.

How to migrate existing users from firebird 2.X to firebird 3?

Firebird 3 is using new method to validate users on the server.
Direct upgrade of security database is therefore impossible.
Described procedure will let you keep the list of firebird 2.X users
and all related information (firstname, lastname, etc.) except
password – new passwords will be generated randomly. Pay attention
that SYSDBA user is not touched – i.e. it will remain as was after
execution of upgrade procedure.
In the commands below replace
‘masterkey’ with actual SYSDBA password for appropriate (2.X/3.0)
firebird server.

In firebird 2.5 backup security database:

gbak -user sysdba -pas masterkey -b {host/path}security2.fdb security.fbk

In firebird 3 restore copy of 2.5 security database:

gbak -user sysdba -pas masterkey -c security.fbk {host/path}security2.5

And run users upgrade sql script:

isql -user sysdba -pas masterkey -i security_database.sql {host/path}security2.5

“security2.5” is a sample database name – you may use any other if you wish.

Upgrade Script will create users with new random passwords and type them to you.
It’s your responsibility to notify users about new passwords.

CVE-2016-1569 : FireBird bug introduced in 2.5.5: authenticated clients crash FireBird when running gbak with invalid parameter

The FireBird RDBMS can be crashed remotely by an authenticated client
by invoking gbak via the service manager using invalid command line
switch and lead to denial of service.

The issue was introduced in version 2.5.5.

Upstream report:
http://tracker.firebirdsql.org/browse/CORE-5068

Upstream fix: 
http://sourceforge.net/p/firebird/code/62783/

Debian bug:
https://bugs.debian.org/810599

CVE-2016-1569 Status in Debian:
https://security-tracker.debian.org/tracker/CVE-2016-1569
1 65 66 67 68 69 200