SQL Server Tools
Devart Becomes the Winner of 2020 CV Magazine Technology Innovator Awards
For more than 15 years, Devart has been developing database tools and data-related solutions. One of its most popular product lines, dbForge, is designed...
Export and Import SQL Server Data to SQL Script (SSMS, CLI, dbForge)
Data migration is a common challenge in the field of database development, management, and administration. This guide will illustrate the process of exporting database data to a .sql file and subsequently importing it into the target database.
Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards
For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products...
Searching for Invalid Objects with SQL Complete
The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and...
Database DevOps Tools for Continuous Integration
Over the past few years, CI has come to be one of the best practices for software development. Indeed, it has numerous advantages: including...
How to Export and Import JSON Data Via dbForge Data Pump for SQL Server
In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and filled...
New Git Client Has Been Implemented in dbForge Source Control v2.2
We are thrilled to announce that a new version of Source Control - our advanced SSMS add-in for SQL Server database change management -...
Find Invalid Objects in SQL Server Databases
In the course of time, we can experience situations when some certain database objects have not been distributed on one or several databases...
Pivot Tables and Reporting in SQL
Quite enough, there’s a need to change how data is displayed in a database so that the users could analyze it more easily. One...
Compare and Find Data Differences Between Two Tables in SQL Server With SSIS and dbForge Tools
Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is...
