dbForge Team posts

In the world of data management, SQL and SQL Server are two of the most commonly used terms. However, even though they both contain the term “SQL,” they do not mean the same thing. So, how do SQL and SQL Server differ from one another? That’s exactly what we’ll be talking about in this article.

The MySQL CONCAT function is widely used to concatenate multiple column values into a single column. In this article, we will look into the MySQL CONCAT() syntax, demonstrate to you how to use it, and explore the differences between CONCAT and CONCAT_WS.

Meet the long-awaited release of dbForge tools for MySQL. We have enhanced them with a few new features that will surely come in handy.  However, the foremost thing in this update is that our tools now can run on Linux and macOS through CrossOver, a solution that helps launch Windows applications on different operating systems.

We are happy to announce the new release of our flagship solution for MySQL – dbForge Studio for MySQL – which is now available on Linux and macOS! Check out the updated features and improvements.

Following the recent release of dbForge SQL Complete, we have rolled out a similar update for the entire SQL Tools bundle. Now every add-in and standalone tool it contains is compatible with SSMS 19 Preview 2, the latest preview release of SSMS.

dbForge Source Control for SQL Server is an SSMS add-in that enables database version control and is compatible with the biggest version control systems, including Git, Mercurial, SVN, TFVC, Azure DevOps Server, Perforce, and SourceGear Vault.

In 2022, Oracle is still the world’s most popular database management system, and it is not going to lose its position anytime soon. Learning Oracle is obligatory for database specialists because chances are sky-high that you will have to develop and administer an Oracle database at some point in your career. In this article, we will explore one of Oracle’s distinctive features – tablespaces. dbForge Studio for Oracle with a whole set of convenient and user-friendly tools will help us throughout this journey.

In this tutorial you’ll discover what PostgreSQL materialized views are and in what cases you should consider working with them. Moreover, you will get familiar with a convenient IDE by Devart – dbForge Studio for PostgreSQL that is designed to make your database development routine easier and more pleasant.

A database scripts folder is a set of scripts that represent a database schema and, optionally, the data contained within. Scripts folders can be used to compare and deploy SQL Server database schemas, as well as version-control and reverse-engineer your databases. All of these operations can be done in a specialized tool called dbForge Schema Compare for SQL Server.

The article provides a general overview of the databases in simple terms, discusses their advantages and drawbacks, and covers the types of data to be used in databases to better understand and more effectively organize your databases.