Here is the approach I have in mind but I am not sure this is the best approach so please give me your opinion:
1. do a full export with no data
2. export the 100 tables with data.
3. do a full import to the new schema.
4. import the 100 tables with ignore=y
any other thoughts????




Reply With Quote