SQL Server Tools

Get the New Update of SQL Tools With Support for SSMS 19

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.

(more…)

Getting Started With dbForge Source Control

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.

(more…)

Using OneDrive to Store Scripts Folders for dbForge Schema Compare

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.

(more…)

What Is a Database?

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.

(more…)

Here Comes a New Update of SQL Complete 6.11 with Support for SSMS 19

We’ve got a new update of dbForge SQL Complete, your favorite add-in for SSMS and Visual Studio that helps you write clean SQL code faster, delivering context-sensitive code completion, debugging, formatting, and refactoring features.

(more…)

Producing Realistic Test Data With SQL Data Generator

Database development is a combination of complex processes that work together in order to create a perfectly balanced (just as all things should be) product. Testing is one of the most important procedures in this process. It is supposed to put a database into the close-to-field conditions and detect any flaws before the production goes down due to any unexpected circumstances. In other words, testing helps convert such circumstances into preventable events.

(more…)

Get the Latest Update of dbForge Studio for SQL Server With a Few Useful Additions

Here comes a minor yet rather helpful update of dbForge Studio for SQL Server, your favorite IDE that helps you easily handle nearly any task related to database development and administration—and makes your daily work with SQL Server databases far easier. Similarly to the recent release of SQL Complete, we have enhanced the Studio with several new functions, which are hardly game-changing, yet are certainly worth having. Let’s take a look at each of them.

(more…)

dbForge Compare Bundle vs Visual Studio Diff Tools: Which One Compares Databases Better?

Identification and management of differences in database objects and actual data is an indispensable part of database management. Without a doubt, you want it to get done fast, easy, and with maximum flexibility of settings.

(more…)

Azure Data Studio vs dbForge SQL Complete: Which One’s Best at Code Completion?

With the right SQL code completion tools by your side, you can get approximately 2 to 4 times more productive with your daily coding routine, as evidenced by our clients in success stories. Empowered with context-sensitive suggestions, advanced code formatting, and productivity boosters, you can streamline monotonous operations and work every day with a far sharper focus on things that require your attention the most. After all, you want to work smart and make it a pleasure, don’t you?

(more…)

dbForge Search vs Redgate SQL Search vs ApexSQL Search: A Comparison of SSMS Add-ins

The three times that the word “search” is repeated in the title of this article might seem an overkill, but what can we do? The feature itself is absolutely crucial to everyone who happens to work with databases in SQL Server Management Studio. You don’t want to be left without a way to quickly browse your databases for a required piece of data or a certain object. And since the search feature is basically absent from SSMS, you will need to enhance it with an add-in.

(more…)