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.
Find and delete incomplete open transactions in SQL Server – Part 3
In two previous articles, we have reviewed a solution for deleting incomplete open transactions in SQL Server.
Read the rest of this entry »How to view the SQL Server transaction log with SQL Transaction Log Reader Tool
Just like any information system, databases are constantly changing. Quite often you need to roll back some operations. There is undoubtedly an opportunity to restore the database to a specific point in time and you can also undo the latest transactions with both regular and third-party utilities.
Read the rest of this entry »Installing and Configuring an ODBC Driver on Linux (DEB / RPM)
This article explains how to install, configure, and test Devart ODBC drivers on Debian-based or RPM-based Linux distributions.