Enjoy Continuous Integration in TeamCity with dbForge DevOps Automation

devops automation tc

We are thrilled to inform our users of dbForge DevOps Automation for SQL Server that we have extended the range of supported automation systems with TeamCity.

Read the rest of this entry »

ODBC Driver: Now with Support for PostgreSQL 12

ODBC driver for PostgreSQL 12

The Devart ODBC team released a new version of ODBC driver for PostgreSQL to support PostgreSQL 12, the latest version of the open-source database. Read the rest of this entry »

dbExpress Drivers with Support for InterBase 2020, PostgreSQL 12, and Oracle 19c

Devart dbExpress team released new versions of dbExpress drivers. New RDBMS versions were supported in respective drivers: InterBase 2020, PostgreSQL 12, and Oracle 19c.
Read the rest of this entry »

How to generate and use CRUD stored procedures in SQL Server

SQL-Complete-Generate-CRUD

Most database systems operate on the basis of 4 simplest data manipulation operations that are called by the acronym CRUD. This acronym stands for Create, Read, Update, and Delete.

Read the rest of this entry »

Devart Supports 64-bit Android App Development in DAC for Delphi

Delphi data access components for Android 64-bit

Devart, the leading provider of database management software and developer tools,  announced the latest version of its data access components for Delphi.
Read the rest of this entry »

Excel Add-ins 2.1 with PostgreSQL 12 Support, HubSpot Web Login, and Other Improvements

Devart is glad to announce the release of Excel Add-ins 2.1 with support for PostgreSQL 12, HubSpot web login, and a number of other improvements for cloud applications. Read the rest of this entry »

New dbForge Fusion tools with Visual Studio 2019 Support

dbForge Fusion is a line of Visual Studio plugins designed to simplify database development and enhance data management capabilities. This line comprises three tools: dbForge Fusion for SQL Server, dbForge Fusion for MySQL, and dbForge Fusion for Oracle.

Read the rest of this entry »

Latest connectivity options in dbForge Data Compare for PostgreSQL v3.2

We are thrilled to inform our PostgreSQL users, that a new version of our ultimate data diffs management tool, dbForge Data Compare for PostgreSQL, v.3.2, has been rolled out. Read the rest of this entry »

How to kill certain connections to a MySQL database

Maintenance of databases or servers is quite often performed by database administrators at night. But these routines sometimes get blocked by long-running queries or applications that hang onto locks much longer than expected.

Read the rest of this entry »

How to Access DBF Databases in Delphi

Access DFB databases in Delphi

xBase is the generic term for all databases deriving from the original dBase database format (.dbf). The list includes Visual FoxPro, Clipper, dBase III, dBase IV, and many others. These databases are informally known as dBase clones because they are either direct descendants of dBase or mimick it.
Read the rest of this entry »