Method and apparatus for data migration between databases

Details Method and apparatus for data migration between databases Method and apparatus for data migration between databases

G - Physics

06

F

G06F 17/30 (2006.01) G06F 17/20 (2006.01) G06F 17/22 (2006.01)

Patent

CA 2437008

The invention herein provides a method, system, and computer readable article for producing a schema mapping transformation for a relational database to allow selected data stored in at least one table in a source relational database having a first schema to be transported to a target relational database having a second schema while preserving integrity of the data and satisfying constraints of the target relational database, including, determining the schemas of the source and target relational databases; developing a mapping transformation mapping the first schema to the second schema in a computer interpretable language; and, processing the mapping transformation into a set of computer readable instructions for directing a computer to transform the selected data from the source relational database into a form suitable for the schema of the target relational database. The mapping transformation can be conveniently performed in a spread sheet, transformed to the XML computer readable language and the n converted in SQL instructions which can the n be run on a computer to migrate code from the source to target databases.

Affiliated with

Also associated with

Rating

Method and apparatus for data migration between databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for data migration between databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for data migration between databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1766821