September, 2010

During replicating data in one or another way, it happens that synchronized objects may differ. This situation may take place in the following cases:

• If changes made in one of copied databases were not captured
• The changes were captured but not forwarded
• The changed were forwarded but not applied due to some reasons

It should be admitted that full or partial synchronization may be required due to some other reasons, not related to replication. But the question is how to synchronize database objects?
(more…)

In the process of developing databases many developers and testers encounter a problem of synchronizing data between local and remote Oracle database. Changes made in a local database must be reflected in a remote database. It’s also necessary to check test results with the model database, to find non-synchronized tables that appeared after these tests, to have possibility to return the test database to its initial state when testing newly developed versions of databases intensively. Another problem may be to create CRUD operations quickly without making too much effort to find different objects and to write DML statements. Now let’s find out how one can synchronize data of Oracle databases.

Simple solutions:
(more…)

When you perform data maintenance operations, sometimes, it’s necessary to disable or enable all foreign keys in the user schema.

Here is the script that solves this task:
(more…)

Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by a community vote.

Devart has been nominated in 4 categories of 2010 DevProConnections Community Choice Awards!
Nominated products:

• Best Add-In Product – Entity Developer (page 1, category 1: Add-In)
• Best Component Set – dotConnect for Oracle (page1, category 7: Component Set)
• Best IDE Product – dbForge Studio for MySQL (page 2, category 14: IDE)
• Best Free Tool – CodeCompare (page2, category 26: Free Tool )

If some of your favorite products are in that list, please visit: http://www.surveymonkey.com/s/DEVCommChoiceFinalVoting and cast your vote for your favorite Devart products.

Note: Voting ends on September 21, 2010.

Thank you and best wishes,
The Devart Team
www.devart.com