How To

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…)

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…)

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…)

Automatic Schema Comparison Log Delivery via Email

In this article, we will show how to set up automatic email delivery of the log file when a comparison of multiple SQL schemas fails. The task will be completed by means of dbForge Studio for SQL Server. Specifically, we will use its command-line functionality, allowing to perform routine tasks in both, command prompt and PowerShell. In this article, we will focus on the command prompt.

(more…)

How to work with dbForge Studio for MySQL on MacOS by using Parallels Desktop

Many database professionals use Mac for their daily work. Devart is going to develop its software products for Mac platform in future. But for now, our users owing macOS devices can face some issues with procuring high-quality and comfortable work. One of the best solutions to resolve such issues is a software called Parallels Desktop. This is a virtualization environment, in which you can run Windows or any other OS while remaining in macOS. Today, we will tell you about the intricacies of setting up the dbForge Studio for MySQL environment in this app.

(more…)

Importing Data by Mask

Introduction

In this article, we will show how to perform routine data export from multiple files by a certain mask with help of the Data Import functionality of dbForge Studio for MySQL and how to schedule the recurring execution of the import with Microsoft Task Scheduler. (more…)

Creating Linked Server in SSMS using ODBC

SQL Server Management Studio is an ideal environment for managing infrastructure of SQL Server database and SQL Server itself. With SSMS, you can easily connect to your SQL Server instance, configure and monitor database objects, as well as execute queries. Besides this, there is a possibility to create an ODBC connection to external data from SSMS.

(more…)