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: Read the rest of this entry »

New release of Data Access Components with support for Lazarus 2.0.2

DAC Support Lazarus IDE 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.

Read the rest of this entry »

How to Connect Oracle Autonomous with Oracle Client

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. Read the rest of this entry »

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

Synchronizing Data How To

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. Read the rest of this entry »

How To Generate and Fill a Doubly Linked List Table

How to Generate 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. Read the rest of this entry »

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. Read the rest of this entry »

Devart sponsored SQLSaturday 857 in Kyiv, Ukraine

SQL Saturday Kyiv 2019

SQLSaturday is one of the largest free-to-attend IT events in Ukraine, and Devart was its Gold Sponsor this time.

We had a lot of new product to show, gave a lot of interesting talks and had many interesting productive conversations. Read the rest of this entry »

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. Read the rest of this entry »

Execution history in SQL Complete

banner_BLOG-Complete_ExecHistory

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. Read the rest of this entry »

How to activate and use SQL Complete Express

CompleteExpress

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.

Read the rest of this entry »