Firebird Database Converter released

Leave a comment
Firebird Database Converter SQL Maestro Group starts a new product family and announces the release of Firebird Database Converter, a powerful and easy-to-use tool to migrate any database to Firebird server in a few simple steps. Key product features include:
  • Copying tables, indexes, and foreign keys
  • Native support for MySQL, PostgreSQL, SQL Server, Oracle, Firebird, and SQLite
  • Support for all other data sources accessible via ODBC / OLE DB
  • Bulk data loading
  • Flexible and customizable data type mappings
  • Smart database integrity checker
  • Command-line interface to automate the conversion

    There are also versions for other DBMS (MySQL, PostgreSQL, SQLite, Oracle, etc). Read full press-release.

    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
    Loading...

    dbMigration .NET 2.5 released

    Leave a comment
    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.

    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...

    Database .NET 17.5 released

    Leave a comment

    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.

    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 5.00 out of 5)
    Loading...

    The Haversine formula => Calculate distance between to WGS84 Points

    Leave a comment

    Hi,
    I think might be helpful, today for a customer i do the Haversine formulas for Firebird Sql as a stored procedure.

    This formula allow you to calculate the distance in meter between two WGS84 datum points(degree points of Earth).

    You can call the procedure like this:

    SELECT * FROM HAVERSINE_GENERIC(1, 45,474081, 9,179348, 45,456091, 9)
    Read full article.
    1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 5.00 out of 5)
    Loading...

    IBProvider v3.27.1. Service update

    Leave a comment

    Hello everyone!

    We glad to inform, that new IBProvider v3.27.1.19598 is ready for download and work in your applications and services.

    http://www.ibprovider.com/eng/news/n_160120.html

    In this release:

    • Better support of big database arrays
    • New compiler for vc14xp binaries
    • Internal changes for code improving

    You can read also:

    • Additional information about previous release (v3.27)
    • Information about direction of our current work

    —
    You can download the Trial of “IBProvider Professional Edition” (32 and 64 bits) from any page at our web site.

    If you want to get the “IBProvider Free Edition” (32 bit only), you need to register on the site:
    http://www.ibprovider.com/customer/login.php

    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
    Loading...

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

    Leave a comment

    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.

    1 Star2 Stars3 Stars4 Stars5 Stars (13 votes, average: 4.38 out of 5)
    Loading...

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

    Leave a comment 
    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 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
    Loading...

    1 … 99 100 101 102 103 … 495