synchronize database

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

Recently we’ve received a question from one of our customers asking how to synchronize data between companies servers and a data warehouse server. Let’s see how easy it can be done with the help of  dbForge Data Compare for SQL Server, a professional tool for data comparison and synchronization.

What we have:

We have two companies ( they use ERP software), each having their own SQL Server database with one table. The companies tables with their customers’ data are saved in the data warehouse as follows:

• The SQL table for company1 is Company1$Customer.
• The SQL table for company2 is Company2$Customer.

What we need:

We need to create a data warehouse with all information stored in one set of SQL tables. For example, the created data warehouse should contain a Customer table that contains all records of Company1$Customer and Company2$Customer.  This table should contain an extra field with a company name to make the records unique. We need to synchronize only changed records.

How to complete the task:

(more…)

Devart today previewed dbForge Studio for MySQL 4.00, scheduled for release this December, and announced the immediate availability of a beta release that supplies database-dealing people with the very data management capabilities they want.

Having accumulated extensive knowledge in data management preferences and routines, Devart has created dbForge Studio for MySQL 4.00 Beta that predicts and delivers expected capabilities in any phase of dealing with data. The users can manage the data from soup to nuts in one place and with the same little effort as usual.

The highlights of dbForge Studio for MySQL 4.00 Beta include:

(more…)

Need to move databases from SQL Server 2000 to SQL Server 2005 – 2008 or vice versa?

(more…)

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

Preserving data in tables after synchronization is one of requirements for successful schema synchronization. dbForge Schema Compare for SQL Server offers two mechanisms of preserving tables data during synchronization, they are warning the users about data loss and restoring data in recreated objects.

But it is not all, dbForge Schema Compare for SQL Server goes on and offers table data verification during synchronization.

How it works

(more…)

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

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 with comparison results

4 ways to exclude all the objects from the synchronization:

(more…)

In dbForge Studio for MySQL you can find Data Compare, a tool which allows you to compare and analyze tables data in databases, for example, to check that data in the synchronized databases are identical. Besides, it  allows synchronizing the data differences to get identical databases. The following picture illustrates comparison and synchronization of two MySQL databases.

Data Comparison Workflow

(more…)

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 comparison tasks, help analyze schema differences at a glance, and synchronize them correctly, saving time and efforts.

dbForge Schema Compare for SQL Server 1.10 features the following enhancements:

(more…)