Wednesday, May 29, 2024

Schema Compare

How to Backup and Restore a PostgreSQL Database

This article contains a comprehensive guide on backing up and restoring data and schema using a command-line tool and a user-friendly GUI tool — dbForge Studio for PostgreSQL. Here, you will discover carefully selected theoretical material designed to broaden your knowledge on the subject, complemented by practical examples to provide you with a hands-on learning experience.

Overcoming the Challenges of SQL Server Version Upgrades and Downgrades With dbForge Compare Bundle

Navigating the process of SQL Server version upgrades and downgrades can be a daunting task, often accompanied by various challenges and complexities. However, with the assistance of the dbForge Compare Bundle, businesses can overcome these hurdles and streamline the upgrade process.

dbForge Schema Compare for PostgreSQL v1.3 Is Out!

To catch up with the rest of the dbForge product line for PostgreSQL, Schema Compare has also received a couple of nice features in the newly released v1.3.

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

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

How to Automatically Synchronize Schema Changes in Two SQL Server Databases on a Schedule

This article introduces a solution on how to automatically synchronize two SQL Server databases on a schedule. Prerequisites To automate and schedule schema changes, we...

Meet Updated dbForge Tools for Oracle

The Devart team worked hard and now we are glad to introduce new features and improvements to one of our remarkable product lines -...

How to Automatically Track Database Schema Changes With PowerShell Scripts

In the article, you will find a detailed guide on how to automatically monitor a SQL Server database for schema changes and automatically create...

Using Object Filters to Adjust Schema Comparison

In this article, you will learn how to apply object filters within dbForge Schema Compare for SQL Server to be able to adjust the...

How to Rename a MySQL Database

Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE...

Azure Database for MySQL: How to Connect and Migrate Databases with dbForge Studio for MySQL

In this article, you'll learn how to connect to Azure Database for MySQL and discover three scenarios of database migration from MySQL to Azure...

How to Synchronize a Table in SQL Server

Database synchronization is an everyday necessity. You need it regularly when you have several similar databases that serve the same “user.” The typical situation is,...

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,...

Continuous Delivery of Database Changes to SQL Server When Working Remotely

In the process of software product development that involves a database, one of the key points is the possibility of continuous delivery of changes...

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

How to Create Custom SQL Server Replication for Read-only Databases

Quite often there’s a need to create a read-only replica of a SQL Server database. This might be required, for example, for the purpose...

A New Look of Differences in Compare Bundle!

We are thrilled to announce a huge update of our SQL Server comparison tool pack,  dbForge Compare Bundle for SQL Server.  The new versions...

Automatic Schema Comparison Log Delivery via Email

In this article, we will show how to set up automatic email delivery of the log file when a comparison of multiple SQL schemas...

New Look and Feel of Compare Bundle for Oracle

We are glad to announce the release of the updated dbForge Compare Bundle for Oracle. The tools of the Bundle, dbForge Schema Compare for...

Extended Connectivity in dbForge Tools for MySQL

We are excited to inform our users that we have released new versions of dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL,...

Reinvented dbForge Tools for MySQL Have Arrived!

After a grand update of dbForge Studio for MySQL, we haven't forgotten about the rest of the dbForge for MySQL product range. Our developers...

Comparing Diffs Between Two Oracle Database Schemas

The article defines main requirements for a tool for Oracle schema comparison (Database Diff tool), provides brief report on different tools offering such functionality, and analyses their shortcomings and advantages.

Schema Compare for Oracle is here – Early Access Preview of the new product

Having successfully released our data comparison tool for Oracle we went further by starting the new one. dbForge Schema Compare for Oracle is targeted...

Moving Database Objects from One Schema to Different Schemas

Database development is not limited to an initial copy of a database. On your road you meet multiple enhancements, refactoring, upgrade and many other...

Ensuring Quality of dbForge Schema Compare for SQL Server, v 2.0

The most important characteristic of any software is its quality. The quality, according to the model specified in the ISO 9126 standard, consists of...

Backup Comparison and Database Versioning Added in Schema Compare for SQL Server

Schema Compare for SQL Server 2.00 compares schema snapshots, database backups, and database changes in version control systems to accelerate the work of advanced...

How to Migrate Databases of Different SQL Server Versions

Need to move databases from SQL Server 2000 to SQL Server 2005 - 2008 or vice versa? dbForge Schema Compare for SQL Server can successfully...

Table data verification for safe schema synchronization

Preserving data in tables after synchronization is one of requirements for successful schema synchronization. dbForge Schema Compare for SQL Server offers two mechanisms of...

Bulletproof database synchronization with dbForge Schema Compare for SQL Server v1.50

Devart, a vendor of native connectivity solutions and database development tools for Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite databases, has announced...

Easy ways to quickly exclude objects from schema synchronization

Many users of dbForge Schema Compare for SQL Server ask us how to exclude all the objects or a group of objects at once...

What’s New in dbForge Schema Compare for SQL Server v1.10

Devart has released today the improved version 1.10 of dbForge Schema Compare for SQL Server, a sophisticated tool specially designed to meet your specific...

dbForge Schema Compare for MySQL to deliver speed, simplicity, and safety!

Dear users, Devart has released today dbForge Schema Compare for MySQL - a special advanced tool for modern comparison and synchronization of MySQL databases. dbForge...

Coming Soon: dbForge Schema Compare for SQL Server v1.10

After analyzing our users' feedback on the first release of dbForge Schema Compare for SQL Server. We decided to change our roadmap for this...

Synchronization script is too large – what shall I do?

In my previous post Schema Comparison Stress Testing I mentioned problems we met testing dbForge Schema Compare for SQL Server on large database. In...

Schema Comparison Stress Testing

A few weeks after the first version of dbForge Schema Compare for SQL Server had been released we received a letter from one of...

Social

Products