Data Transferring Among Different Structure Database Based On Java

In this paper, data migration between heterogeneous database background, concepts, meaning and purpose are briefly introduced. With constantly updated database management system progress, database application technology has gradually matured. From the early development environment based on the dos Foxbase as the database to the small management information systems, windows-based environment using Foxpro, Access, and other information management system developed by Sybase and until today, represented by large oracle database system. Applications also gradually upgrading from single-machine environment for the C / S, B / S architecture. Therefore, the further development of the system or systems integration, information integration between heterogeneous database problems appear to be particularly prominent. The original opening from the old system to be replaced by the new system, in its use often during accumulated a lot of valuable historical data, many of which are new historical data systems necessary for the smooth opening. Data migration is the historical data cleansing, transformation, and loading to the new system in the process. Banking, telecommunications, tax, business, insurance and sales in the areas of switching system, the general need for data migration. Data migration to the new system and the system's switching operation is very important. Data migration is not only the quality of on-line success of the new system an important prerequisite, but also the future stability of the new system running strong guarantee. Java support multiple DBMS, a variety of databases provide rich interfaces for different databases at the same time the data transfer to provide a flexible mechanism. Therefore, the use of the Java programming language issues, completed between Oracle and SQL Server data migration.In this paper the development of language and system development environment as a brief introduction. This Java programming language it simple, object-oriented, not dependent on the structure of machines with portability, robustness, security, and provided with a mechanism with very high performance. In addition, Java also provides rich class library so that the procedures designers can easily build their own systems. This paper is in Borland Jbuilder Java development environment for development. The environment for the Java platform application lifecycle management technology suite key part. It is designed for the development team to provide the necessary development tools for enterprise application development process to maximize their productivity, provide the next generation solutions to enable the development team to do more work: to reduce development costs, delivery of consistent, high-quality applications, shortening products listed time. JBuilder environment to facilitate the development process, it is pure Java development environment for enterprise J2EE development; SQL Server 2000 is Microsoft has introduced SQL Server database management system to the latest version. SQL Server 2000 to meet the requirements of today's business environment of different types of database solutions. It's a widely used database management system, has many significant advantages: ease of use, suitable for the scalability of distributed organizations for the data warehouse decision support functions, server software and many other closely related to the integration, cost-effective and so good. Oracle is Senior Structured Query Language (SQL) as the basis for large-scale relational database, it is used simply to facilitate manipulation of the language of logical management of a large number of data sets. Is the most popular client / server (Client / Server) database architecture one. Oracle9i as the first comprehensive, simple software infrastructure, has demonstrated unprecedented scalability, high-performance and application procedures required by the stability of the Internet system is provided specifically for the new generation of intelligent integrated application software.In this paper, the feasibility of the system were studied. The system currently used as a wider use of the Windows XP operating procedures and operating environment, JBuilder2005 used as a software development tool, as a connecting JDBC SQL Server 2000 and Oracle9i database interface. Current Java JDBC technology development environment and more mature, so the software is technically feasible. Enterprises in system replacement or upgrade, we can use this tool, in the original database does not change the basic data types and content of the circumstances, the successful transfer of data. After the implementation of systems, enabling management of complicated work of extricating themselves, driven enterprises into modern management stage, save a lot of manpower and material resources and financial resources, data management system more scientific, standardized, rationalized. Besides the hardware and software required by the system environment is not high, it is economically feasible. This system has been designed on the basis of user needs, using human interface operation, the operation can be used for at least complete functionality. Basically, users can only use the mouse to achieve all operators. The general staff, as long as certain basic computer, can be used directly, without computer based, can be a little training, operation is feasible.In this paper, the system design done elaborate. To achieve the function of the system, the most important issue is how to achieve both the migration of data between databases, and data migration is the so-called data from a data environment into another kind of environmental data in a thorough and accurate data conversion should be guided by the following key steps: identify data sources, identified conversion of data integration rules, the rules of conversion development code.In this paper, the function of the system to achieve a expounded. Programming system through SQL Server 2000 and Oracle9i data migration between specific completion of the module and the module's functions to achieve the following:Connectivity Series modules. Completion of SQL Server and Oracle database connection string changes.SQL Server data area module. Completion of the SQL Server database and Table tree display.Oracle Data District modules. Completion of the Oracle database and Table tree display.The operation area module. Completion of SQL Server and Oracle database connectivity, table creation, deletion and table migration.Operating results module. Completion of the operation area of the results, including the field of information, data in the table, migration, the creation of new forms of sql statement and the system running log.System was completed, the system passed the test, the basic realization of the above functions, complete with SQL Server 2000 data migration between the Oracle9i. Of course, the system also have shortcomings, such as single-table can only achieve the migration of the data did not support all types, and so on.