Invention Grant
US07827134B2 System and method for transferring data and metadata between relational databases
有权
在关系数据库之间传输数据和元数据的系统和方法
- Patent Title: System and method for transferring data and metadata between relational databases
- Patent Title (中): 在关系数据库之间传输数据和元数据的系统和方法
-
Application No.: US11030534Application Date: 2005-01-05
-
Publication No.: US07827134B2Publication Date: 2010-11-02
- Inventor: Bruce A. Prang , Ciprian Gerea , Dmitry Sonkin , James Kirk Haselden , Jeffrey R. Bernhardt
- Applicant: Bruce A. Prang , Ciprian Gerea , Dmitry Sonkin , James Kirk Haselden , Jeffrey R. Bernhardt
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Woodcock Washburn LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
A script driven infrastructure is provided in order to selectively move structure and data from a source database to a target database. The structure and data is moved using a data transfer mechanism, where the data is contained in disk files stored on the source database and it has corresponding script files describing the structure of the data. The transfer of the data is driven by the script files which allows for selective transfer of structure and data. In one aspect of the invention, the disk files are stored in SQL format and the script files are saved in SQL format and XML format, where the script files saved in SQL format create objects and relational constraints in the target database, and the script files stored in XML format drive the transfer process of the data stored in the disk files.
Public/Granted literature
- US20060149706A1 System and method for transferring data and metadata between relational databases Public/Granted day:2006-07-06
Information query