dbForge Team posts

Audit and Rollback Transactions Live with dbForge Transaction Log for SQL Server

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, recover data, and easily revert unwanted transactions.

(more…)

Shared vs Dedicated Development Models: Key Differences

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 conflicts, and roll back to the earlier versions if needed, the good solution will be to use a version-controlling tool. It can also help developers to compare versions and identify what changes have been made and who is the author.

(more…)

Azure Data Studio vs SSMS: Who’s the Winner?

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 “blueberry pie.” But then a contender emerged, developed and released by the same Microsoft folks in 2018. It was Azure Data Studio – obviously less mature, weaker in terms of database administration, yet very promising and eager to win its audience. And today, we’re going to put them face to face and find out who’s better.

(more…)

How dbForge Studio for MySQL is Involved in the DevOps Process

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 the problem of repeated recovery of test data arises. This article offers the simplest way to automate the process using only one tool – dbForge Studio for MySQL.

(more…)

Devart Joins the Winners of 2020 ComponentSource Bestselling Awards

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.

(more…)

Manage Your Sensitive Data With SQL Data Discovery and Classification in SSMS

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.

(more…)

ADD SENSITIVITY CLASSIFICATION Command in SQL Server 2019

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.

(more…)

Meet dbForge Schema Compare for PostgreSQL, v1.0!

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.

(more…)

Working With Multiple Branches in Source Control

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.

(more…)

Version-controlling Static Data: Conflicts

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.

(more…)