Here you can read special articles for introductory information about what you can do with conversion and synchronization tools and when they can be necessary. Presented articles offer some possible solutions that can help you to make the right choices to keep your databases up-to-date.
If you have your own point of view on particular conversion questions you are welcome to share your ideas here. Every rational approach will be considered and published. You can contact us via e-mail esupport@dbconvert.com.
 |
|
|
|
|
Synchronization is the process of data uploading or mirroring between two or more databases. When you work with converters you can face some issues attempting to synchronize tables in your databases. Here you can find answers how to overcome them.
|
|
|
|
|
|
Having some new records in the table in your source database, you have an opportunity to add them in the table in your destination database with the help of our converters from Database Conversion Product Line.
Additional records easily and quickly inserted from a source to a destination, in case there are no records with identical Primary key values.
The result of the synchronization is the added records from a source to a destination if there are no coincident records in the last one. The following scheme show a simple example of insert synchronization work.
|
|
|
|
Changing table in your source database, you would like to adjust your table in a destination database to desired result.
Converter will replace the altered records without any problems. It compares the value of records in order to establish identity between two tables.
The result of update synchronization is keeping all your data updated. This is shown schematically in the given below scheme.
|
|
|
|
You have modified your table in your source database. For example, you changed some data in existing records and inserted entirely new records in that table.
You have to add these values in the table and renew data in your destination database.
Insert Synchronization and Update Synchronization together allow you flawlessly to accomplish complex synchronization.
The result of synchronization is identity of the data. Destination database entirely matches the source database. The subsequent process is shown schematically in the following scheme.
|
1. Database conversion
Database conversion is a process of transforming database from one DBMS into another one without a loss of data accuracy, usually for the purpose of application interoperability. If you work with several DBMS simultaneously such as MS Access, MS SQL, MS FoxPro, MySQL, PostgreSQL, Oracle, and others you may need to migrate your databases from one platform to another.
2. Why do we need it?
Below you will see several cases when database conversion may (might) be required.
With the developing of new technologies there appeared new versions of different operating systems and not every DBMS can be installed on a newly launched OS version. Also newest versions of DBMS can perform high reliability, stable kernel and some new features. It may happen that they cannot run on old versions of operating system.
Generally there exist standard datatypes supported by great number of DBMSs, such as strings, binaries, integers, etc. Unfortunately there can be such a situation when you have a certain datatype that can't be presented in your DBMS but supported by another one. For example sometimes it is a problem to store the specific data such as XML; however, only new DBMSs can work with this datatype.
Usually a database management system has a standard set of characteristics like data performance, data security, concurrent access and so on. But sometimes the newly launched DBMS versions have some new additional capabilities oriented to a special user group. As not every DBMS can support these new features you may need to transform your database.
If you want to share your data from the desktop database to a multiuser on-line DBMS it is necessary to transform a single-user DBMS into a multi-user one. It could be done for the case when several users have access to one database at the same time.
Security is also an important requirement, since the system maintains sensitive information to be shared by multiple users with different levels of permission. Many DBMS companies aim to improve the level of protection of their database management systems. In other words they have developed a lot of new security polices, improved data encryption. Therefore using newly developed DBMS with high security level can prevent your data from being lost.
3. How it works
For making the process of converting quick and easy the special equipment called database converters was developed. Database Converter is oriented to transforming the information from a source database to a target one. DB Converter is a database migration program capable of converting tables, primary keys, indexes, foreign keys and other database components. Such a program can usually support various database formats and often performs high speed and accurate data conversion. Sometimes database converters alongside with conversion can synchronize database structure and records in tables of your databases. Usually this program includes a well-designed user interface that allows user to easy understand migration stages of database converter.
![](images/z.gif"){kind=small}
