Products

Backing Up All MySQL Server Databases or Only the Required Ones

When having only several databases to manage, regular backup operations can be done quite easily and seamlessly either with the help of a few simple scripts or by configuring an SQL Server agent that will perform the backup automatically. But sometimes the situation is more complicated. When, for instance, there are hundreds of databases, backing up each one manually can turn out to be quite a time-consuming task.

(more…)

Linking and Comparing SQL Server and PostgreSQL Databases

In this article, we will describe how to link a PostgreSQL Database to SQL Server, compare and deploy the PostgreSQL data against SQL Server with the help of dbForge Studio for SQL Server.

The workaround for the task suggested in this article consists of three major steps: (more…)

New release of Data Access Components with support for Lazarus 2.0.2

The long-waited update of Delphi Data Access Components is finally here – Devart is rolling out new versions of  DAC products.

This release introduces support for Lazarus 2.0.2, improved performance of the SaveToFile/LoadFromFile methods of TVirtualTable, a new DefaultSortType property for TVirtualTable, and a range of other smaller but nonetheless important updates.

(more…)

How to Connect Oracle Autonomous with Oracle Client

Oracle Autonomous Database is a powerful technology that provides data processing and management in the cloud for self-driving, self-securing and self-repairing databases which can operate with no human intervention. So, it’s quite unsurprising that many want to know how to establish a connection between Oracle Client and Oracle Autonomous. Let’s take a look at how this can be achieved. (more…)

How to automatically synchronize data in two SQL Server databases on a schedule

Data in SQL databases often needs to be synchronized in real time – this can be achieved by checking one database for updates and then applying them to another database. In this case, the process of change detection and synchronization should be ran automatically on a schedule and with no need for outside intervention. (more…)

How To Generate and Fill a Doubly Linked List Table

Introduction

In this article, we’ll learn how to fill a doubly linked list table with SQL test data. In such tables, there can be various independent chains unified by unique tags into groups. (more…)

Welcome to the Future of SQL Database Development!

We are thrilled to announce the most notable addition to our dbForge for SQL Server product line in years, dbForge DevOps Automation for SQL Server. (more…)

Cutting-edge IDE for PostgreSQL Keeps Gradually Improving

We are delighted to inform our PostgreSQL users about the release of a new version of our PostgreSQL GUI, dbForge Studio for PostgreSQL, v2.1! Day by day, our developers are working to make the tool the ultimate solution for everything PostgreSQL. In this release, along with traditional bug fixes,  we introduced a new connectivity option, a brand new feature for optimizing queries, as well as a number of notable improvements to Code Completion, and Database Explorer. (more…)

Execution history in SQL Complete

dbForge SQL Complete includes the whole range of options that provide possibilities for powerful optimization and great performance increase. Execution history is an important part of this list. It is included into the Standard and Express edition package. The feature stores basic information about executed SQL statements for a certain period. (more…)

How to activate and use SQL Complete Express

dbForge SQL Complete is a multifunctional add-in for SSMS that simplifies the development and administration processes greatly. Our users have an opportunity to use this tool in two editions: Standard and Express. The availability of a free Express edition appears after the 30-day trial Standard. Let’s see what the user has to do to start using dbForge SQL Complete Express.

(more…)