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 »

Find and delete incomplete open transactions in SQL Server – Part 3

how to delete lost transactions 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

How To Read Transaction Logs SQL Server

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)

Installing ODBC driver on Linux

This article explains how to install, configure, and test Devart ODBC drivers on Debian-based or RPM-based Linux distributions.

Read the rest of this entry »

New Versions of ODBC Drivers: Oracle, PostgreSQL, QuickBooks, xBase

New versions of ODBC drivers for Oracle, PostgreSQL, QuickBooks were released with improved compatibility with Power Pivot, Visual Basic, and RStudio.

Read the rest of this entry »