New in Delphi DAC: Support for RAD Studio 10.4

Delphi DAC for RAD Studio 10.4

We are very excited to announce the release of our Delphi DAC products with support for the newly released RAD Studio 10.4 Sydney.

Read the rest of this entry »

SSL Connection to MySQL From Delphi with UniDAC and SecureBridge

SSL Connection to MySQL From Delphi

This article explains how to establish an SSL connection to MySQL from Delphi with UniDAC and SecureBridge.

Read the rest of this entry »

New version of dbForge Source Control for SQL Server released

We are excited to announce that a new version of the SSMS add-in for SQL Server database change management, dbForge Source Control for SQL Server, v2.1, has been just rolled out!

Read the rest of this entry »

MySQL Minitools 9.0 Release

MySQL Minitools 9.0 Release Notes

We are very glad to tell you about the release of dbForge Minitools 9.0 for MySQL.

The tools comprising the release got new great features such as script folder comparison for Schema Compare and Data Compare, support for new database objects types, an ability to configure default values in the Data Synchronization wizard, and many more updates and fixes.

Read the rest of this entry »

How to Create Tables using MySQL CREATE TABLE Statement and via GUI Tool for MySQL

create table query MySQL

There are two main ways of creating tables in MySQL databases:

Read the rest of this entry »

ODBC Driver for Google BigQuery Released

ODBC Driver for Google BigQuery

Devart announced the release of ODBC Driver for Google BigQuery.

Read the rest of this entry »

Discover new dbForge Studio for MySQL 9.0 hugely packed with new stuff

We are excited to announce that the new version of our MySQL IDE, dbForge Studio for MySQL, v9.0, has been just rolled out!

Read the rest of this entry »

Installing and Configuring an ODBC Driver on macOS

Installing ODBC driver on macOS

This article covers the installation and configuration of Devart ODBC drivers on macOS.

Read the rest of this entry »

Export SQL Stored Procedure to a File and Generate its Script

Find and delete incomplete open transactions in SQL Server - Part 4

In previous articles, we have reviewed a general algorithm of finding and deleting incomplete open transactions in SQL Server databases, created a table for fixing incomplete transactions and a CRUD-stored procedure, and implemented numerous settings that will make our document workflow productive and handy.

Read the rest of this entry »

How to create a many-to-many relationship

Establishing a many-to-many relationship between the tables in a database is usually done for ensuring efficient data processing and data integrity, as well as for database normalization and data analysis tasks.

Read the rest of this entry »