Data migration method and server

The invention provides a data migration method and a server, which can be applied to the technical field of databases, and the method comprises the following steps: reading a CDC log in a current database; the CDC log is used for recording data change information in a database; generating a first SQ...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: LIN JIANHAI
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention provides a data migration method and a server, which can be applied to the technical field of databases, and the method comprises the following steps: reading a CDC log in a current database; the CDC log is used for recording data change information in a database; generating a first SQL (Structured Query Language) statement corresponding to the CDC log in the current database; under the condition that the first SQL statement is not executed in a target database, first data migration operation is executed, and the first data migration operation is that the first SQL statement is sent to the target database, so that the target database executes the first SQL statement. Thus, whether the first SQL statement is executed in the target database or not is determined before data migration, then the first SQL statement is executed in the target database which does not execute the first SQL statement, and the problem of repeated migration is avoided. 本申请提供了一种数据迁移方法及服务器,可应用于数据库技术领域,该方法包括:读取当前数据库中的CDC日志;所述C