If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
A number of ETL tools will automate the process, but it is pretty simple.
1) Migrate the schema (making any adjustments needed for features used that are not supported in the earlier version)
2) Copy the data from the full database back to the empty one.
-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
take db2look in 9.5 and execute this in a new db in 9.1
export all data 9.5 and load in 9.1
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified http://www.infocura.be