Integrating two installs of CS2.0

Reply

gwawr Posted: Thu, Apr 5 2007 8:19 AM

rated by 0 users

I've an interesting issue.

I'm migrating from a small snitz forum to CS2.0. I'm therefore using the migration tool to CS1 and then upgrading.

I've not completed this migration yet, and I know it has its own headaches, but I'm thinking ahead to the next stage. the end goal is to integrate the forums, post migration, with an existing install of CS, currently running blogs only.

 I'm looking, therefore at integrating two Community Server MS SQL databases. Which tables should I look at carrying across from the migrated "forums only" CS into the current "blogs only" CS? And what headaches and pitfalls can you guys forsee me having to navigate around?

Reply

John Bledsoe replied on Thu, Apr 5 2007 8:49 AM

rated by 0 users

That's going to be a pain, because CS doesn't store forums and blogs in neatly divided tables.  (Most) every bit of content in CS is a "post", stored in cs_Posts, with ancillary information stored in other tables.

Reply

gwawr replied on Wed, Apr 11 2007 8:55 AM

rated by 0 users

I know it's going to be a pain! ... I was hoping for a pointer or two on which tables I will need to start fiddling with the indexes of. I'll get digging and see what I come up with :/

Reply

gwawr replied on Wed, Apr 11 2007 10:07 AM

rated by 0 users

OK a couple of specifics :

cs_ProductPermissions - what impact does this table have? The role IDs and ApplicationType values vary widely between the two installs

cs_SearchBarrel - can I safely leave this table behind when integrating?

Reply

gwawr replied on Wed, Apr 11 2007 12:08 PM

rated by 0 users

checking the data and the diagram of FK relationships, so far I can see the following list of tables being essential. Have I missed any out or could this be said to be definitive in order to retain integrity?

cs_Groups
cs_Posts
cs_ProductPermissions
cs_SectionPermissions
cs_Sections
cs_statistics_Site
cs_Threads
cs_statistics_User