Method for Import With Replace That Eliminates Filling the Log File
Original Publication Date: 1989-Apr-01
Included in the Prior Art Database: 2005-Jan-27
Disclosed is a method for importing data into an existing table and replacing all records in that table with a minimal amount of logging. In a relational database management system, data in the database is stored in tables consisting of rows and columns. There are times when it is necessary to move data from one database to another. The Import and Export functions are a means of doing this. The Export function extracts data from one database (call it an "external system") and stores the data in a separate file, using a pre-defined interchange format. This file is then taken to another database (call it the "current system") and imported into a single table in that database. The imported data can be placed into a newly created table, added to an existing table, or can replace all rows in an existing table.