We are thrilled to inform our customers that the new version of dbForge Schema Compare for PostgreSQL has been rolled out. The release brings a number of new features and major improvements… Read More

dbForge Studio is a product line designed to encompass every aspect of database development and administration, providing versatile functionality in a single IDE. It is available for all maj… Read More

We are honored and thrilled to announce that dbForge Studio for SQL Server has received recognition as “High Performer” and “Easiest to Do Business With” in Summer 20… Read More

This article will show you how to create and manage views in MySQL. A view is a virtual table that does not store its own data but rather displays data that is stored in other tables. Essent… Read More

We released new versions of dbExpress drivers to support Oracle 21c, PostgreSQL 13, and InterBase OTW encryption. The latest versions of PostgreSQL and Oracle Database were supported in the… Read More

The article covers a step-by-step guide describing how to install a SQL Server Express edition on the computer. Microsoft SQL Server Express is a free version of Microsoft’s SQL Server… Read More

We are pleased to announce the release of ODBC Driver for HubSpot that provides access to HubSpot inbound marketing, sales, and customer service data from various analytics, database managem… Read More

We are pleased to announce the availability of MSI installers for all Devart ODBC drivers. The new installer format provides better corporate deployment, thereby reducing time and cost. Wind… Read More

The article presents a detailed overview of the Code Debugger functionality that comes with dbForge Fusion for MySQL – a powerful MySQL development add-in for Visual Studio. During the… Read More

Microsoft Visual Studio plugins continuously compete to empower users with extended capabilities. Free tools have the most obvious advantage — while you don’t have to pay for the… Read More

We are pleased to present the new version of Transaction Log 2.1 – our advanced tool for reading transaction logs and analyzing the history of data changes. What’s new in Transac… Read More

We are delighted to inform our dbForge for SQL Server users that we have just released the hugely updated pack of our SQL Server tools, dbForge SQL Tools, v.6.0. Take a sneak peek of new fea… Read More

In this final part of the three-part article series, we will review creating a script, wrap it in a stored procedure, and will use it for deleting all local temp tables and one particular lo… Read More

The article deals with the Visual Studio add-ins for Oracle database development and management and provides an extensive comparison of two contenting add-ins for the aforesaid purpose, dbFo… Read More

In this article, we share a step-by-step guide on how to compare the schema and data of multiple SQL Server databases from the command line. Both dbForge Schema Compare for SQL Server and db… Read More

As you may have heard, Apple has started shipping Macs with its own custom-designed Arm-based chip called M1. ODBC drivers for Mac require the iODBC driver manager, but it appears that the c… Read More

As you may have heard, Apple has started shipping Macs with its own custom-designed Arm-based chip called M1. ODBC drivers for Mac require the iODBC driver manager, but it appears that the c… Read More

We are thrilled to announce new versions of ODBC drivers for popular database systems with support for the Apple Silicon M1 chip. Last year Apple announced plans to transition away from Inte… Read More

Having a database under source control brings huge benefits. Therefore, we decided to review and compare two popular version control tools, dbForge Source Control add-in for SSMS and Visual… Read More

Summary: In this article, we will demonstrate how Review Assistant can significantly simplify tracking renamed or moved files. You will learn how to keep track of file name changes and easil… Read More

This article focuses on the database storage engines for MySQL that ensure appropriate performance and manage SQL operations for multiple table types. The article examines the differences be… Read More

This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a MySQL database. Learn the basics of user account managemen… Read More

The article provides a detailed overview of how to create a database in MySQL using different methods and tools (including the Command Line, Workbench, and dbForge Studio for MySQL). MySQL i… Read More

One of the regular jobs performed by a database administrator and developer is creating and executing queries of higher complexity to resolve complicated tasks. This requires extra caution a… Read More

The article presents a step-by-step guide to SQL INSERT INTO statement. You will learn the basic principles underlying this command and see how to implement this statement visually using dbF… Read More

Very often, developers and QAs need to load a large amount of test data to assess the speed of populating the database with generated data and analyze how the performance changes with the da… Read More

If a company has to choose between a free database tool and a paid one, and both of them deliver the same features and performance, it is natural that the paid one doesn’t stand a chan… Read More

This is the fifth part of an extensive article dedicated to database versioning. Before you proceed to it, we suggest that you read the previous parts: Part I: Version Control with Git Part… Read More

There are many solutions for version-controlling databases. We are going to review one of them, namely Source Control which comes in the SQL Tools pack. As an example, we will use the JobEmp… Read More

The article provides a complete walkthrough to help you create a TFVC repository in Azure DevOps and link your database to the repository via the Source Control tool by dbForge. You will be… Read More

We are glad to announce new versions of the ODBC drivers for Salesforce, Dynamics 365, and Zoho CRM. The most notable updates include OAuth 2.0 authentication for Dynamics 365 and Salesforce… Read More

In this article, you will learn how to apply object filters within dbForge Schema Compare for SQL Server to be able to adjust the schema comparison and synchronization process to your needs… Read More

The MS SQL Server database management system suggests that all changes are carried out via transactions. Transactions are created to ensure the ACID requirements: A – Atomicity. All op… Read More

dbForge DevOps Automation helps to automate SQL Server database development, testing, and deployment. It was designed to minimize deployment risks and speed up the release cycle, making the… Read More

Version-controlling SQL Server databases in GitHub has never been easier with Devart solutions. You can commit and revert changes, view and resolve conflicts, track changes and link static d… Read More

The article presents a detailed tutorial on MySQL JOINs. In it, you will learn about different types of JOINS that are supported in MySQL, their syntax, and how to use them. Introduction to… Read More

Database statistics are a powerful weapon. They store a vast array of information about the database data that helps identify slow-running queries and allows you to devise an algorithm to op… Read More

To properly manage the database development process, stay informed of the changes delivered by other developers, and avoid conflicts or missing data in the database, one needs database versi… Read More

Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. How… Read More

Once again, ComponentSource announces its Bestsellers of the year. This well-known professional resource researches the popularity of different software products each year. The analysis grou… Read More

dbForge Studio for SQL Server is an all-encompassing IDE, designed for efficient development, management, and administration of SQL Server databases. It comprises a set of tools that acceler… Read More

Quite often, migrating a database proves to be a cumbersome task. You have to control both schema and data changes introduced into the database. If you intend to build a reliable automation… Read More

The article deals with the basics of versioning SQL Server databases and goes into the basics of working with the Git version control system. Table of Contents What is a versioncontrol syste… Read More

Devart is glad to announce the release of Entity Developer 6.11 – a visual ORM designer for a wide variety of ORMs. The new version introduces support for Entity Framework Core 6, grea… Read More

The third article in the series about SQL Server backup and restore will take us through the database restore process and demonstrate the two main principles of database restore available in… Read More

When raising issues related to increasing performance and improving Oracle database reliability and integrity while developing and deploying databases, the real value lies in automating the… Read More

Now that we have reviewed the backup basics in the first article of our series dedicated to SQL Server backup, let’s proceed to the implementation and automation of the SQL Server back… Read More

We have been developing our own SaaS CMS platform floowedit since 2007. During all the development and improvement phases we have always faced a problem: having realistic and quantitative te… Read More

The importance of database backup and restore can be neither underestimated nor ignored. And since your data is subject to modification, the primary task is to ensure its safety and mitigate… Read More

dbForge Studio for MySQL is one of the most famous and valuable Devart products – a comprehensive solution with an intuitive interface for MySQL and MariaDB database developers, admini… Read More

Learn how to safely rename a column in a MySQL database using a universal multi-featured tool – dbForge Studio for MySQL. To paraphrase Heraclitus, the only constant is change. Th… Read More

Oracle 20c, PostgreSQL 13, and SQL Server 2019 were supported in respective ODBC drivers. We are pleased to announce the release of new versions of our ODBC drivers, with the most notable up… Read More

Devart is glad to announce the release of Entity Developer 6.10 and the new versions of dotConnect ADO.NET data providers for Oracle, MySQL, PostgreSQL, and SQLite. New versions of Devart pr… Read More

Summary: This article will demonstrate a code review workflow when using Git as a repository and Review Assistant as a code review tool. You will learn how to set up an effective code review… Read More

In this article, you’ll learn how to connect to Azure Database for MySQL and discover three scenarios of database migration from MySQL to Azure using dbForge Studio for MySQL. The arti… Read More

We are excited to announce the release of Devart SecureBridge with support for the SMTP and SMTPS protocols. A new component — TScSMTPClient — was added to SecureBridge to suppor… Read More

Every single year new products and new versions of the leading tools enter the market. Their providers compete, offering database specialists  more and more features. Thus, users have a… Read More

Devart is glad to announce support for the latest PostgreSQL version – PostgreSQL 13 – in the newly released dotConnect for PostgreSQL 7.19 and SSIS Data Flow Components 1.15 as… Read More

Today we’d love to unveil a big update of dbForge Transaction Log for SQL Server. This tool was designed to provide detailed information on all changes in your SQL Server database, rec… Read More

Extended Events is a helpful and convenient solution designed to monitor your system performance. First introduced in SQL Server 2008, it has become the global default solution. SQL Server E… Read More

The data stored in the history of queries are among the most valuable for any DBA. Tracking back the SQL Server query history is a must in many cases. For instance, there might be a need to… Read More

Database synchronization is an everyday necessity. You need it regularly when you have several similar databases that serve the same “user.” The typical situation is, they must b… Read More

Developing databases in a secure and efficient way is very important for each database developer in the team. To maintain and keep an eye on any changes made to the databases, resolve confli… Read More

For 15 years, SSMS has held the title of the top SQL Server database tool. That’s no easy feat, especially in the software world, where things can change faster than you say “blu… Read More

When developing a software application based upon complex database structure, it is often necessary to run diverse business logic test scenarios on the same input data. That’s where th… Read More

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers. New versions of Devart products offer significant improvements for Entity Framework Core and… Read More

Devart is glad to announce the release of Entity Developer 6.9 – a visual ORM designer for a wide variety of ORMs. The new version supports two more third-party providers for Entity Fr… Read More

The new release of dotConnect ADO.NET providers for Oracle, MySQL, PostgreSQL, and SQLite support Spatial data in Entity Framework Core 3. Entity Framework Core 3 does not limit entities to… Read More

The response and appreciation of our users make our company proud of the database solutions we create. This time Devart gladly joins the ranks of Top 25 Bestselling Publishers on ComponentSo… Read More

The 17.5 version of SQL Server Management Studio (SSMS) brought with it a new built-in security tool. Since then, the Data Discovery and Classification feature has become a difference-maker… Read More

For a database administrator, the common everyday practice involves running multiple operations targeted at ensuring database security and integrity. Thus, we shouldn’t overlook the im… Read More

We are proud to announce the release of a new product from the dbForge Tools for PostgreSQL line – dbForge Schema Compare for PostgreSQL, v1.0. The tool is best suited when you need to… Read More

In the process of software product development that involves a database, one of the key points is the possibility of continuous delivery of changes from the development environment to the pr… Read More

With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in dbForge Studio for SQL Server, you can quickly connect data… Read More

Version-controlling static data is vital to maintaining a normalized database structure. The article presents a simple and comprehensive guide through the process of resolving static data co… Read More

We are pleased to present the latest version of our superior solution for SQL Server database development, management, and administration – SQL Complete v6.6. The update is packed with… Read More

We are glad to announce that a new version of dbForge Data Compare for PostgreSQL v.3.3 is available for download. In this release, we have extended connectivity options to provide the possi… Read More

Unit testing is an essential component of the database DevOps process. Its primary goal is to test the constituent parts of the database objects in order to identify any malfunctions or flaw… Read More

We are excited to announce that new versions of Delphi data access components are now generally available. All DAC products received support for the latest versions of Lazarus (2.0.10) and F… Read More

In our fast-changing world, observations of certain events, operations, and processes determine the development of business and implementation of any solutions or ideas. Such observations ar… Read More

For more than 15 years, Devart has been developing database tools and data-related solutions. One of its most popular product lines, dbForge, is designed to facilitate and simplify database… Read More

We quite often face the task of migrating database directory data. And the database for a recruitment service, which we created in the previous series of articles, is no exception. In this a… Read More

For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products as winners among the world’s top… Read More

We are glad to announce that the new version of dbForge Studio for PostgreSQL has been just released! Here’s what you can find in our updated IDE: Script Generator Improvements New opt… Read More

The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and the ways of finding them in the SQL… Read More

Hello and welcome to the fourth part of our series of articles that will help you discover how to design and work with databases. This time we are going to delve into an intricate matter of… Read More

Following the best practices of RDBMS involves the consistent usage of Primary Keys when designing databases to create and enforce Referential Integrity which is a major requirement for… Read More

The overwhelming popularity of MySQL means that people need convenient tools to work with it. Software providers compete to produce the best MySQL client. However, the goal is not to develop… Read More

Devart is glad to announce the release of Excel Add-ins 2.5 with support for secure SSL and SSH connections to Oracle in the Direct mode. Now you can connect both to on-premises Oracle and O… Read More

In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and filled the newly-created database with test data… Read More

In this article, we will examine the process of populating the employee database with dummy data, whose schema we designed in the previous part. Filling a SQL database with dummy data can be… Read More

It is a common practice that a DB architect has to design a relational database tailored to a particular solution. One Friday evening, I was coming home from work on a commuter train, and I… Read More

Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components 1.14. Now you can connect both to on-premises Oracle and… Read More

We are thrilled to announce that a new version of  Source Control – our advanced SSMS add-in for SQL Server database change management – has been released. The most not… Read More

The necessity to export data from Amazon RDS to the on-premises MySQL database may be spawned by various reasons such as a user request, an upgrade to a system, data consolidation, need for… Read More

Importing and exporting data are common tasks involved with administering databases. Migrating data between on-premises and cloud databases can be frustrating especially if the jobs need to… Read More

In the course of time, we can experience situations when some certain database objects have not been distributed on one or several databases or database instances. This can happen for a numb… Read More

We are glad to inform our Oracle users, that the new versions of dbForge for Oracle tools have been just released. The new versions of all dbForge for Oracle tools feature connectivity suppo… Read More

We are excited to announce the release of Devart SecureBridge with support for the recently released RAD Studio 10.4 Sydney. Our suite of client and server components  for SSH, SFTP, FT… Read More

Quite enough, there’s a need to change how data is displayed in a database so that the users could analyze it more easily. One of the cases of such transformation is transposing data f… Read More