QuoteReplyTopic: is it possible to run a forum from two DB sources? Posted: 16 October 2011 at 8:59pm
Is it possible to run a forum from two DB sources? (two different MSSQL DB hosted on two different servers)
if i want to establish duplicated new forum, when the older will stil be updated only by the old domain community but in the new domain it will be updated from both servers (different servers) the old and the new so i will get combined forum withe new & the old community.
forum 1 will be forum 1 (regular)
forum 2 will be forum 2 + forum 1 (combined) dont care about the differences of TID PID PF etc. from that point on in the new forum
i want to be connected to 2 databases Simultaneously on the new forum only (read from 2 mssql DB's) so that the new forum wil be updated from two Sources & will be the Comprehensive one.
Future changing to the posts will be written to 1 DB only (the new one).
I don't understand the objective (logically not technically). If you want posts in both databases then logically (referential integrity) the members who posted those posts must also be in both databases.
I thought about MSSQL replication features...but I suspect you need to say more about the goal and also the detail.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum