--- add hold fields for old ids....
ALTER TABLE DB1.FORUM_MEMBER ADD OLD_MEMBER_ID int;
ALTER TABLE DB1.FORUM_CATEGORY ADD OLD_CAT_ID int;
ALTER TABLE DB1.FORUM_FORUM ADD OLD_FORUM_ID int;
ALTER TABLE DB1.FORUM_TOPICS ADD OLD_TOPIC_ID int;
ALTER TABLE DB1.FORUM_REPLY ADD OLD_REPLY_ID int;

--- start with members and category since those are the basic parent levels....
SELECT MEMBER_ID AS OLD_MEMBER_ID, M_STATUS, M_NAME, M_USERNAME, ... INTO DB1.FORUM_MEMBER
  FROM DB2.FORUM_MEMBER;

SELECT CAT_ID AS OLD_CAT_ID, CAT_STATUS, ... INTO DB1.FORUM_CATEGORY
  FROM DB2.FORUM_CATEGORY;

-- now work on the children...
SELECT C.CAT_ID, FORUM_ID AS OLD_FORUM_ID, F_STATUS INTO DB1.FORUM_FORUM
  FROM DB2.FORUM_FORUM F, DB1.FORUM_CATEGORY C
 WHERE F.CAT_ID = C.OLD_CAT_ID;

SELECT F.CAT_ID, F.FORUM_ID, TOPIC_ID AS OLD_TOPIC_ID, T_STATUS, ... INTO DB1.FORUM_TOPICS
  FROM DB2.FORUM_TOPICS T, DB1.FORUM_FORUM F
 WHERE T.FORUM_ID = F.OLD_FORUM_ID;

:
: REPEAT FOR ALL CHILDREN
:
- get rid of extra fields
ALTER TABLE DB1.FORUM_MEMBER DROP OLD_MEMBER_ID;
ALTER TABLE DB1.FORUM_CATEGORY DROP OLD_CAT_ID;
ALTER TABLE DB1.FORUM_FORUM DROP OLD_FORUM_ID;
ALTER TABLE DB1.FORUM_TOPICS DROP OLD_TOPIC_ID;
ALTER TABLE DB1.FORUM_REPLY DROP OLD_REPLY_ID;

quote:

---

Originally posted by laser

Dave, I don't expect anything to be tested, I think this one is a first ! Anyway, great idea on the "OLD_" fields, I was going to just execute a bunch of UPDATE commands to alter all the necessary IDs, but yeah it's a huge job!

---