Devart Blog

schema compare

Comparing Diffs Between Two Oracle Database Schemas

Posted by on February 28th, 2011

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

Posted by on December 24th, 2010

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
  • analyse changes between databases
  • generate schema comparison reports
  • synchronize databases immediately or save sync scripts for later use

In order to allow our users 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

Posted by on July 2nd, 2010

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

More Tools Available: dbForge Studio for MySQL, v4.50!

Posted by on June 21st, 2010

Devart today releases dbForge Studio for MySQL, v4.50 – cutting-edge administration tool and development environment for professional working with MySQL databases.

With dbForge Studio, Devart continues its initiative to produce efficient database experiences for all the people in MySQL world.

New features in dbForge Studio for MySQL, v4.50 include:

(more…)

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

Posted by on February 2nd, 2010

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

Posted by on January 29th, 2010


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

Posted by on November 30th, 2009

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?

Posted by on October 23rd, 2009

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

Bulletproof database synchronization with dbForge Schema Compare for SQL Server v 1.50

Posted by on September 17th, 2009

Devart, a vendor of native connectivity solutions and development tools for Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite databases, has announced the release of dbForge Schema Compare for SQL Server 1.50, a sophisticated tool specially designed to meet a diversity of comparison tasks, help analyze schema differences at a glance, and synchronize them correctly, saving time and efforts.

With the new release, Devart continues its dedication to providing a line of safe as well as powerful tools for SQL Server database synchronization.

The highlights of Schema Compare for SQL Server 1.50 include:

(more…)

Easy ways to quickly exclude objects from schema synchronization

Posted by on August 4th, 2009

Many users of dbForge Schema Compare for SQL Server ask us how to exclude all the objects or a group of objects at once from synchronization. It is not a problem.

Pay attention to the document with comparison results. In the middle of the grid, just between Source Objects and Target Objects columns, you can see two columns – one with check boxes (they will help you exclude the objects from the synchronization or include them), the other – with operations which will be applied to the Target objects during the synchronization.

Document scomp

Document with comparison results

4 ways to exclude all the objects from the synchronization:

(more…)