The article describes such ways of data synchronization of Oracle databases as Advanced Replication, Oracle Streams, GoldenGate. Also it gives a brief comparison of shortcomings and benefits of each way for data comparison and synchronization tasks when developing and testing databases.
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...
Devart today unveiled a new data comparison tool, dbForge Data Compare for Oracle. It delivers automatic data comparison in Oracle databases, provides a convenient...
Recently our development efforts were focused on dbForge for SQL Server product line. We've made five major releases of SQL Server database tools in last 18 months. Besides, we've made two major releases of MySQL database tools in this period. Our Oracle database tools product line, once actively developed, was frozen for almost three years. Sure we made maintenance releases, but no new features and tools. Our Oracle tools even were not re-branded to dbForge for Oracle. But now we decided to breeze the new life into Oracle tools development.
Data comparison is a difficult and resource-intensive process. In the article, we are going to explore algorithms, advantages, and disadvantages of specific data comparison,...
Welcome to the Devart development blog of dbForge product family.
We'll publish here articles on development, product usage tips, issue workarounds etc for MySQL, Oracle,...