手工,请参考。
This paper researches and analyzes the techniques, methods and tools of the heterogeneous relational database migration, and proposes to design a heterogeneous relational database migration software making use of Delphi as IDE and the two classic relational databases SQL Server and Oracle as reference. This paper adopts the ADOConnecton widget to connect the databases of both sides firstly, and then uses ADOQuery widget to collect the modes and data information of the relational databases and translates them into standard SQL and PL/SQL blended statement, and finally executes in the Target relational database in order to realize the effect of migration.
After the research and analysis of the techniques,methods and tools of heterogeneous relational database migration ,this article advised to use the Delphi as programing environment,two typical relational database--SQL Server and Oracle-- as references,and designed a software applied to heterogeneous relational database migration.First,this article connected both the databases by the ADOConnection widget,then extracted the source relational database mode and data information by the ADOQuery widget and transformed it into standard sentences that mixed by SQLand PL/SQL and finally executed them in the target relational data base to achieve the effect of transformation.
Based on the migration of heterogeneous relational database technology, methods and tools of analysis, the proposed use of Delphi as a programming environment for two typical SQL Server and Oracle relational database as a reference, to design a heterogeneous relational database migration software. This paper uses ADOConnection database connection for both control and then extract the source control using ADOQuery relational database model and data, convert it to standard SQL and PL / SQL statement to mix, the last of them in the target relational database implementation, in order to
This article through to heterogeneous relational database technology, methods and transplantation of research and analysis tools, this paper USES Delphi after programming environment, as with SQL Server and Oracle two typical relational database as reference, design a kind of heterogeneous relational database transplant software. This paper firstly adopts ADOConnection controls on both sides database connections, then use ADOQuery control mode of extracted source relational database and data, converts it into standard SQL blended with PL/SQL statement in target relation database, at last, to achieve the transplantation of implementation effect. Heterogeneous relational database relational database heterogeneous transplantation: migration Programming environment: IDE Relational database relational database: Control: widget Mode: mode