Products

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 ComponentSource, based on sales orders placed by their customers over the course of a year.

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 in the protection of sensitive information.

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 importance of sensitive data stored in the database under any circumstances. In light of this, we are excited to demonstrate the new ADD SENSITIVITY CLASSIFICATION command introduced in SQL Server 2019, which allows adding the sensitivity classification metadata to database columns.

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 compare Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

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 production environment.

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 databases you’re working on to your version control system of choice and easily switch between different branches.

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 conflicts with the help of the dbForge Source Control plugin.

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 improvements and the major one is the support for the ADD SENSITIVITY CLASSIFICATION command introduced in SQL Server 2019.

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 possibility to work with the latest PostgreSQL database engine. Also, we adjusted the Pre & Post Script execution functionality that helps you perform additional operations before and/or after data synchronization.

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 flaws early in the project. This approach allows database developers to ensure the changes they have made are verified, and the project will work properly. In our article, we will mainly focus on unit testing a stored procedure in a SQL Server database and exemplify how simple it is to conduct unit tests with the dbForge Unit Test tool.