Database to database transfer

In a lot of the examples we have seen so far in the book, we have used files of different sorts to be the conduit for the data. Specifically, data is extracted to a file or imported from a file. However, it is perfectly possible for data to be passed directly from one system to another, which often means from one database to another. We will look at an example of this database-to-database transfer in this section. The job we will build will transfer data from our example database to a second database named DB2DB (there is a script to create the database and an associated table in the ResourceFiles folder of this chapter). The new database contains a table named order_data containing the following fields:

• order_date

• order_id

• line_id

• order_status

• product_id

• product_name

• brand

• unit_price

• quantity

• extended_price

All of these fields are contained within our original database, with the exception of extended_price, which we will have to construct. (Extended price is commonly...