Products
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...
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 write complex MySQL queries?
Advanced queries aimed to solve complex tasks or multiple tasks constitute an essential part of any database administrator or developer job. MySQL complex queries...
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...
