New in Delphi DAC: Support 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.
SSL Connection to MySQL From Delphi with UniDAC and SecureBridge
This article explains how to establish an SSL connection to MySQL from Delphi with UniDAC and SecureBridge.
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
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
There are two main ways of creating tables in MySQL databases:
Read the rest of this entry »ODBC Driver for Google BigQuery Released
Devart announced the release of ODBC Driver for Google BigQuery.
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
This article covers the installation and configuration of Devart ODBC drivers on macOS.
Export SQL Stored Procedure to a File and Generate its Script
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.