Method for synchronously migrating data in heterogeneous database
The invention provides a method for synchronously migrating data in heterogeneous databases. The method comprises the following steps: S1, connecting a source end database and a target database by using a driving program; s2, SQL query parameters are input into the drive program, then required data...
Gespeichert in:
| Hauptverfasser: | , , , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | The invention provides a method for synchronously migrating data in heterogeneous databases. The method comprises the following steps: S1, connecting a source end database and a target database by using a driving program; s2, SQL query parameters are input into the drive program, then required data are queried in the source end database, and the required data are stored in a target table in the drive program; and S3, writing the data in the target table into the target database to realize data synchronous migration. According to the heterogeneous database data synchronous migration method, two-way transmission between the source end database and the target database is supported, the range of data migration synchronization can be controlled through the SQL statement, full-amount synchronization of all fields, synchronization according to fields, synchronization according to conditions and increment synchronization are supported, and the mode is simple and easy to operate.
本发明提供了一种异构数据库数据同步迁移的方法，所述方法包括：S1、使用驱动程 |
|---|