schema compare

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 Oracle and dbForge Data Compare for Oracle,  have been improved in-and-out. Besides the great new visual style, the tools include a bunch of new features and options that will definitely make your data and schema diffs management more smooth and convenient. (more…)

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, dbForge Query Builder for MySQL, dbForge Data Generator for MySQL, and dbForge Documenter for MySQL. (more…)

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 took maximum care of each and every MySQL tool and revamped them with specific new features and updates. (more…)

Comparing Diffs Between Two Oracle Database Schemas

When developing databases, we frequently need to check what changes were made to its schema, if any mistakes were made, and, if there are any, we should roll back to the working version saved in the source control system. To do this, it’s enough to compare schemas of version 1.1 and 1.2, and generate an UPDATE SCRIPT using any Database Diff tool, including our dbForge Schema Compare for Oracle.

So what functionality should be available in such tool?

Firstly, the tool should be easy-to-use and user-friendly. A user should not be obliged to learn a pile of topics in the tool documentation before using it. It should be enough to perform the following set of steps:
1) Select Source and Target
2) Select a schema or several schemas (if the tool provides such possibility) for comparison
3) Tune comparison process by checking the needed options (an optional step)
4) View comparison results
5) Tune script generation options (an optional step)
6) Generate an update script and/or execute it directly to the target database
Secondly, the tool should support comparison of all object types you might have in your schemas – otherwise, how the tool is supposed to look for differences in them? And, at last, the tool should be fast. This point is especially important for searching data differences when a comparison of several schemas is performed, or the size of the project itself is large.

Now let’s look at Oracle SQL Developer and its alternative — dbForge Schema Compare for Oracle. Both are offering schema comparison functionality.
(more…)

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 to help database developers perform sustainable change management process. The tool is designed to:

  • compare Oracle schemes
  • analyze changes between databases
  • generate schema comparison reports
  • synchronize databases immediately or save sync scripts for later use

In order to allow our users to make changes and improve product even before the first release, we decided to publish early access preview of the dbForge Schema Compare for Oracle.

Visit product page http://www.devart.com/dbforge/oracle/schemacompare/ download product and leave us a feedback.

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 cases that require changes in a database structure. One of most common cases is to upload database objects from one schema to several schemas. Here the simplicity ends and you are stuck with the questing ‘How to do this?’

Upload manually or automatically?

(more…)

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 the following characteristics:

  • Functionality
  • Reliability
  • Ease of use
  • Efficiency
  • Maintenance
  • Portability

Of course users are not concerned about any quality models and just tell us their suggestions and wishes. It’s these suggestions and wishes that are the most preferred description of any quality characteristic.

(more…)

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


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

Devart today announced the public availability of  Schema Compare for SQL Server 2.00 that delivers new capabilities to help customers more effectively compare databases and more quickly migrate schema changes across different SQL Server versions.

Featuring new functionality, the tool is better equipped to span a full spectrum of database comparison and synchronization tasks and allows completing them at a professional level.

The highlights of Schema Compare for SQL Server 2.00 include:

(more…)

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?

(more…)

Would you like to change data types or other attributes for multi tables in one shot?

Recently we’ve got a letter from a customer asking how to alter all float datatype to double datatype in one “Find and Replace all” shot. Good news! dbForge Studio can do this.  Let’s see how Find and Replace functionality,  Schema Compare tool,  and a database project of dbForge Studio will do their best to change the required properties at a heat.
(more…)