Products
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...
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.
By incomplete transaction, we shall basically understand an...
How to Install and Configure ODBC Drivers on Linux
This article explains how to install, configure, and test Devart ODBC drivers on Debian-based or RPM-based Linux distributions.
Table of contents
What is an ODBC Driver?...
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.
The compatibility with...
Entity Developer 6.7 with Console App, .NET Core Support Improvements and More
Devart is glad to announce the release of Entity Developer 6.7 – a visual ORM designer for a wide variety of ORMs. The new...
Migrating Data From Oracle to PostgreSQL
In the article, you will learn how to migrate table data from Oracle to PostgreSQL using the dbForge tools.
Adopt Flawless Continuous Integration into Bamboo with a New dbForge DevOps Plugin
We are glad to inform our SQL Server users that we have just extended the compatibility of dbForge DevOps Automation for SQL Server with...
How to Create Custom SQL Server Replication for Read-only Databases
Quite often there’s a need to create a read-only replica of a SQL Server database. This might be required, for example, for the purpose...
Find and Delete Incomplete Open Transactions in SQL Server – Part 1
Frequently enough, MS SQL Server open transactions are incompleted and their initiators forget about them. This is quite a commonly encountered situation in routine...
How to Create a Pivot Table in PostgreSQL Using the crosstab Function
A typical relational database table contains multiple rows, quite often with duplicate values in some columns. Data in such a table is usually stored...
