![]() ![]() Navicat Premium and Navicat for MySQL support synchronize between MySQL and MariaDB. RAW primary key cannot synchronize (insert, update, delete) with Database Link to any server, without error. ![]() TIMESTAMP primary key cannot synchronize (insert, update) with Database Link to 9i server. Note:įor Oracle server, BLOB, CLOB, NCLOB, LONG and LONG RAW data are skipped during the data synchronization process. To open a saved profile, select the profile and click Load button or double-click it in Profiles tab. I have used the ER Diagram view to create a useful diagram of an old database. The messages indicate the running process success or failure are saved in file - LogSynchronize.txt. I am using Navicat for MySQL 16.0.14 - Standard, on macOS. You could apply Structure Synchronization before Data Synchronization. Select Tools -> Data Synchronization from the main menu.Īll tables must contain primary keys and all table structures must be identical between the source and target. You can save your settings as a profile for setting schedule. You are not only authorized to rollback the transferring process, but also insert, delete and update records to the destination. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. Because of the problem of encryption, you need to modify the encrypted rules when you use mysql8.0 to connect to Navicat. Data Synchronization (Available only in Full Version) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |