How To

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

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

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

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

Very often, there is a need to compare or synchronize data between two databases on the same server. To detect differences, you can simply use dbForge Data Compare for PostgreSQL, which allows you to perform this process with a few clicks. (more…)

In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio for MySQL.

(more…)

The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of the Direct mode in a custom application does not require the installation of client libraries, additional drivers, etc. This helps to avoid the overhead when accessing a DBMS, hence increasing performance.

(more…)

Custom relational management is very important once you run a business. It helps to improve marketing strategy, sales and customer service. (more…)

Cloud-based CRM systems are becoming incredibly popular in these days. This trend is quite clear. The usage of cloud services does not require a deployment and costly specialized software domestic support, which ultimately reduces a company’s total expenses. (more…)

In this article, we will discuss how to access data using ODBC driver in Microsoft Excel. We will examine in detail the data retrieving process.
Cloud technologies develop rapidly, more and more data is stored in the cloud. (more…)