I am looking for suggestions on the best way to do the following.
I have a production database using raw files on BCV disks. The database is 7.31.FD5 IDS. It is approximately 250 GB.
Once a week I need to split off a copy of the BCV disk, mount it to a different server and database. From there I will move the data off to a new database (using cooked data files) on the same server .
I want this process to be dynamic so if a column gets changed on the production system, I don't have to change any scripts.
The part I need help with is the best way to move (unload, export, etc) the database once it is mounted on the new server and get it into a new database. I have a process for the rest.
I've toyed with the dbexport/dbimport, but it seems to be extremely slow for a smaller (67 GB) database. I will have approximately 48 hours each week to accomplish this process.
Thanks for the suggestions.
I have a production database using raw files on BCV disks. The database is 7.31.FD5 IDS. It is approximately 250 GB.
Once a week I need to split off a copy of the BCV disk, mount it to a different server and database. From there I will move the data off to a new database (using cooked data files) on the same server .
I want this process to be dynamic so if a column gets changed on the production system, I don't have to change any scripts.
The part I need help with is the best way to move (unload, export, etc) the database once it is mounted on the new server and get it into a new database. I have a process for the rest.
I've toyed with the dbexport/dbimport, but it seems to be extremely slow for a smaller (67 GB) database. I will have approximately 48 hours each week to accomplish this process.
Thanks for the suggestions.