SQL Server Tools

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…)

Create ER Diagram for SQL Server Database Using SSMS and SQL Designer

Entity Relationship Diagrams are widely used for analyzing database structure and troubleshooting issues with logic or deployment. In this article, we provide a detailed walkthrough of what an ER Diagram is and how to create and manage database diagrams.

(more…)

How to Compare Two Formatting Styles in dbForge SQL Complete

One of the primary features of dbForge SQL Complete—a top-tier add-in for SSMS and Visual Studio—is code formatting, which helps beautify SQL code and make it consistent and easy to read, understand, review, and share across teams.

(more…)