| Author |
 Topic  |
|
|
Jeepaholic
Average Member
USA
697 Posts |
 Posted - 14 January 2004 : 12:19:55
|
Hey there...looking for some additional information and/or insight on merging two existing forums into one MEMBERS table and one DB.
I know that in theory, all that needs to happen is that a duplicate set of tables with a different prefix needs to be created (we'll call them F2 for reference), and that reference needs to be changed in one of the config.asp files.
So, for purposes of this discussion, F1 is the existing forum with the main user table. F2 is the forum that's being migrated into F1. Now...the difficulties will arise in the fact that I already have two functioning, separated forums. SO, my questions / thoughts are as follows:
1) The only tables that should NOT be duplicated are the MEMBERS table and the MEMBERS_PENDING table, correct? All others will need to exist? Just verifying.
2) What's the best way to create a set of new tables with a different prefix in F1 that will contain all the indexes, PK, FK, etc?
3) I will probably just use a basic DTS copy from F2 to F1 once all the tables have been created, in order to migrate the data to the new DB.
4) I will probably also just copy the MEMBERS from F2 into the F1 MEMBERS table. This will create new MEMBER_ID's for each person, and I will have to update the new MEMBER_ID's in topics/replies/what else?
5) I'm thinking of creating a temporary "OLD_MEMBER_ID" field in F1 prior to the copy, and migrating the F2 MEMBER_ID to that field to help with the conversion of topic/reply/etc. Thoughts?
6) I will have to validate duplicate accounts and prune accordingly (based on email and username), as some folks have signed up on both systems.
7) ? What else am I not thinking of ? I feel like there's something else I'm missing, but I'm not seeing it just yet. Thoughts?
Thanks,
Al |
Al Bsharah
Aholics.com
Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
|
Edited by - Jeepaholic on 14 January 2004 12:24:09 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 January 2004 : 12:43:06
|
Here it goes, one by one (well... almost):
quote:
Originally posted by Jeepaholic
1) The only tables that should NOT be duplicated are the MEMBERS table and the MEMBERS_PENDING table, correct? All others will need to exist? Just verifying.
Not really. I guess the badwords and namefilter tables can be kept in a single version as well.
quote:
2) What's the best way to create a set of new tables with a different prefix in F1 that will contain all the indexes, PK, FK, etc?
Change all the prefixes in config.asp (strTablePrefix, strMemberTablePrefix and strFilterTablePrefix) to the desired value. Run setup.asp to create the tables. Then delete the unwanted members (and pending) and badwords and namefilter tables.
quote:
3) I will probably just use a basic DTS copy from F2 to F1 once all the tables have been created, in order to migrate the data to the new DB.
Yeah. Make sure you configure DTS to delete existing data and enable identity insert.
quote:
4) I will probably also just copy the MEMBERS from F2 into the F1 MEMBERS table. This will create new MEMBER_ID's for each person, and I will have to update the new MEMBER_ID's in topics/replies/what else?
Also in forum_moderator, forum_subscriptions, forum_allowed_members.
quote:
5) I'm thinking of creating a temporary "OLD_MEMBER_ID" field in F1 prior to the copy, and migrating the F2 MEMBER_ID to that field to help with the conversion of topic/reply/etc. Thoughts?
Sounds like a good idea.
quote:
6) I will have to validate duplicate accounts and prune accordingly (based on email and username), as some folks have signed up on both systems.
7) ? What else am I not thinking of ? I feel like there's something else I'm missing, but I'm not seeing it just yet. Thoughts?
Most issues seems to have been considered by you. For now I can't think of anything else.
<changed wanted to unwanted above, sorry for the mistake>
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 15 January 2004 04:59:43 |
 |
|
|
Jeepaholic
Average Member
USA
697 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
|
|
Topic Locked
Going to ponder some more...