SSMSBoost vs dbForge SQL Complete

Code auto-completion can be a popular and useful technique for developers productivity who strive to write clear, accurate, and reliable code with little time and effort. As a rule, code completion tools provide context-based suggestions for code in the SQL editor, thus, helping stay focused, saving much time on daily coding tasks, and minimizing keystrokes.

Read the rest of this entry »

Build Prediction Sales Analytics with Power BI Desktop using Devart ODBC for Oracle

This tutorial is to build the Sales Analytics dashboard by leveraging Power BI Desktop, Devart ODBC for Oracle driver and Oracle Database. It will not be used as the instruction on how to work on PowerBI Desktop or Oracle Database Engine instead we will demonstrate how we will work with Devart ODBC for Oracle driver.

Read the rest of this entry »

15 Best MySQL GUI Clients for macOS

Well, we can’t argue that Windows is the key platform for database development and management software—but what if you are a Mac user? Who said you can’t have equal opportunities to set up easy daily work with, for instance, MySQL databases? Simply take a closer look and you’ll see an abundance of top-tier MySQL tools for your Mac just around the corner. To make your search easier, we have prepared and reviewed a handy selection for you—most of the following tools definitely rank among the best of their kind and boast an appropriately convenient graphical user interface.

Read the rest of this entry »

Data and Schema Comparison Log Delivery to Email

In this article, we will demonstrate to you how to set up automatic email delivery of the log file in both cases: when SQL data and schema comparison goes well and when it fails. The task will be completed by means of dbForge Data Compare and Schema Compare. Specifically, we will use the tools’ command-line functionality to configure the automatic log delivery.

Read the rest of this entry »

MySQL Variables – Definition and Examples

MySQL variables store data, label data, and let developers create more accurate and efficient code by turning long and complicated strings of characters into one simple variable.

This article will explore user-defined variables.

Read the rest of this entry »

Champs Recap: Award-Winning dbForge Products in Q2-Q4 2022

Following our previous recap that covered the awards garnered by dbForge products in Q1 2022, and a compelling selection of DBTA 2022 Readers’ Choice Awards, we believe now is the perfect moment to catch up with the rest of the year as it’s coming to a close. We have gathered all of the accolades in one place—and as it turned out, there’s a whole lot of them to tell you about. Now sit back, relax, and enjoy the ride!

Read the rest of this entry »

New Versions of ODBC Drivers Released

New Versions of ODBC Drivers

We are glad to announce the release of new versions of some ODBC drivers for databases and cloud applications.

Read the rest of this entry »

How to Install SQL Server on Linux (Ubuntu)

It may be news to many database developers and administrators that SQL Server actually performs better on Linux. In this article we will go into how to install SQL Server and SQL Server command-line tools on Ubuntu and show how to connect to the server remotely.

Read the rest of this entry »

10 New ODBC Drivers for Marketing, Planning and Collaboration Services, and More Released

We are excited to announce the release of new ODBC Drivers. Devart ODBC drivers allow easy access to these sources from various ETL, BI, reporting, and database management tools and programming languages on x32-bit and x64-bit Windows.

Read the rest of this entry »

ODBC Driver for Dynamics 365: macOS and Linux Versions Released

We are pleased to announce the release of macOS and Linux for the Dynamics 365 ODBC driver — a high-performance connectivity tool with enterprise-level features for accessing Dynamics 365 from ODBC-compliant reporting, analytics, BI, and ETL tools.

Read the rest of this entry »