|
Jeepaholic
Average Member
USA
697 Posts |
 Posted - 02 March 2004 : 18:10:34
|
Hey folks, been fumbling with this issue for a little while. I run a number of forums with a single user database. I'm trying to create a system that will allow posts, and/or entire forums to be "replicated" across all sites. That way, a single post in one location will show up on all (as well as replies, modifications, deletions, etc).
Some info on the work I've done thus far...
My first attempts had all the work being done inside a Trigger. However, when you're acquiring data from the "INSERTED", "UPDATED", or "DELETED" tables as the database is modified...you CANNOT acquire data in that is of "text" format within the database. So, simply selecting what was added/modified/deleted and plugging it into the other sites doesn't work.
My second (and most lengthy) attempt has the trigger adding a record to a separate table, identifying the type of work that needs to be done on what fields (i.e. Topic or Reply? ID#. Is it an Insert, Delete, or Update? What ForumID did it originate from? What site did it originate from? etc...)
I wrote a VB.NET console application that runs every minute. When it runs, it will parse through this new separate table and perform the functions (if the posts match a forum that is allowed for replication). Each post is mapped across each forum with a new GUID that is assigned to it upon replication. This is how the system finds all the identical posts (as they'll have different ID's across the forums). I still think this one is doable, but I'm running into one scenario after another that needs to be accounted for and it's getting deep.
For example, within this one minute...a single post could be added, modified, replied to, then deleted. The system somehow has to account for this, and ignore posts that don't exist, then don't add the replies, blah blah blah...it's a mess.
I guess I'm looking for suggestions...
1) Has any one done this before?
2) What methodologies am I not considering? Is there a better way to accomplish this?
3) Any other thoughts?
Thanks folks...
AL |
Al Bsharah
Aholics.com
Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
|
|
Topic Locked
