HOw to extracts data from tables in database. Merges them into one output file. This output file is loaded into another tables in database.
Hi,
Welcome to the forum.
You need to understand about the database connections through Unix.\
There are lots of threads available about that. Just search within this forum.
steps you will need basically --
- connect to database
- use spool/bcp/into outfile utility based on which database you are using.
- merge the files ( cat? )
- check file for correctness.
- connect to other database
- use sqlloader/bcp/load data infile or other utility based on which database you are using.
Hope it helps.
1 Like