SAP DB Migration Question

Question:
Hi, we wish to refresh/replace our DB with a heterogeneous DB export
from our other system.
We are using the System Copy/Migration method and using the database independent method.
The export has been performed and we have a MIGRATION_EXPORT file.
As our target system already exists and we are replacing it, should we delete the database first then perform the installation of the DB instance via SAPinst as if it is a new DB, or, is there a way to copy over the top of the existing DB and just replace it?
Our Target is windows 2003 server, ECC5 and DB2
Cheers
TinTin
Answer:
Our Target is windows 2003 server, ECC5 and DB2
And your source is?
Answer:
Source is AIX, DB2 and ECC5.
When I did the original install I used a migration export DVD to create the database instance. They've sent me the same again albeit an updated version so I was wondering if I just delete the existing DB and start again from SAPinst with the Database Instance installation using the latest export.
Cheers
Answer:
As our target system already exists and we are replacing it, should we delete the database first then perform the installation of the DB instance via SAPinst as if it is a new DB, or, is there a way to copy over the top of the existing DB and just replace it?
You should just run SAPinst and load the database by pointing to the exported database files. SAPinst will skip certain steps.
Answer:
Great thanks! Will give it a go straight away
Answer:
I get several errors in the log files during the DB load which read like this example:
http://gmgoldsmith.co.uk/RefreshError.doc

Does this suggest the existing DB can't be refreshed and must be deleted first or is there a way around this?
Answer:
Does this suggest the existing DB can't be refreshed and must be deleted first or is there a way around this?
Yes. Existing database needs to be dropped and removed first. But all software can stay.

More Articles:

Payresults table?
Documentation on SAP archiving?
Populating a Vendor Z-Table?
Redo log sequence out of order?
Transport request Log display?
Want to add a dropdown to a free text field?