Other Scholarly Content

 

db2db : a database migration tool Public Deposited

Downloadable Content

Download PDF
https://ir.library.oregonstate.edu/concern/defaults/pv63g7565

Descriptions

Attribute NameValues
Creator
Abstract
  • We developed a tool that migrates the database schema and the data from one database to another. As DBMSs store the same data by using slightly different data types, one cannot simply copy all the tables and data from the source DBMS to the target DBMS. When our tool, db2db, migrates a database, from Oracle DBMS to PostgreSQL DBMS, for example, it converts such data types as CLOB, NUMBER, VARCHAR2 of Oracle to data types text, numberic, and varchar, respectively, of postgreSQL. The program uses JDBC type-2 or type-4 drivers that work with TCP/IP sockets, which allows a user to migrate databases over a network As a JDBC type 2 driver can connect to a DBMS that support ODBC, db2db can migrate a database from any DBMSs that support JDBC or ODBC.
Resource Type
Date Issued
Academic Affiliation
Rights Statement
Publisher
Peer Reviewed
Language

Relationships

Parents:

This work has no parents.

Items