How To

Pivot Tables and Reporting in SQL

Quite enough, there’s a need to change how data is displayed in a database so that the users could analyze it more easily. One of the cases of such transformation is transposing data from rows to columns in SQL Server.

(more…)

Compare and Find Data Differences Between Two Tables in SQL Server with SSIS and dbForge Tools

Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is necessary to constantly maintain the synchronization of a particular data segment. It is also necessary to check the synchronization itself. This is when the need to compare data in two tables appears.

(more…)

How to convert MySQL data to PostgreSQL

Transferring data between two different servers is not an easy task as it requires a great deal of effort and accuracy, especially when migrating from one database management system to another. In this article, we provide a visual walkthrough of MySQL data migration to PostgreSQL Server.

(more…)

Is UNPIVOT the best way for converting columns into rows?

To start with, let’s give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server.

(more…)

How to import and export CSV files into a PostgreSQL database

CSV files provide a great way to collect and store data, and they are often used as a reliable way to move table data between servers. In this article, we’ll look at two ways of importing and exporting PostgreSQL tables from and to CSV files – using the built-in import and export functionality of dbForge Studio for PostgreSQL and using the COPY command.

(more…)

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.

(more…)

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:

(more…)

Installing and Configuring an ODBC Driver on macOS

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

(more…)

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.

(more…)

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.

(more…)