Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Merging Databases
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

acech
Starting Member

26 Posts

Posted - 08 December 2005 :  05:51:33  Show Profile
Hi all,

I am fairly new to Snitz and I have to say I am extremely impressed by how good the forum software is. I have recently installed two forums using Snitz and I now wish to merge them together as one forum but with the different forums as different categories.

I know that I am going to have to script it to renumber IDs etc, but I was just wondering if anyone had done this before, or if there is an easy way before I write a script to do it!

Many thanks for your time,

Chris

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 08 December 2005 :  06:17:41  Show Profile  Send pdrg a Yahoo! Message
afaik you'll be best off to do this for yourself - as you're clearly aware of renumebering/referential integrity etc you won't find this too challenging - just make sure you start with the parent tables and then work down to the children.
Go to Top of Page

acech
Starting Member

26 Posts

Posted - 08 December 2005 :  07:00:50  Show Profile
Thanks Pdrg,

I will give it ago this afternoon. I think that it should be relatively straight forward, although I intend to script it so that it happens automatically, ie very little downtime for the forums!

I will try and write a howto incase anyone wishes to do this in the future!

Many Thanks,

Chris
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 08 December 2005 :  11:41:21  Show Profile  Send pdrg a Yahoo! Message
great stuff - please post it up here once you're done :)
Go to Top of Page

acech
Starting Member

26 Posts

Posted - 12 December 2005 :  09:24:07  Show Profile
Blimey! That took longer that expected! I think the issue that took the time was that I was merging two snitz forums and one other forum that I wrote myself with over 32000 messages in it!

All worked in the end lovely though except a few statistics which I will now need to update! Do you think that it is worth me writting a howto article on this? If there is likely to be any interest I will give it a go!

Thanks for your support!

Chris
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 12 December 2005 :  10:47:47  Show Profile  Send pdrg a Yahoo! Message
always worth documenting what you did - post it up here so people can search it, it'll become part of the collaborative body of knowledge that this forum is!
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 12 December 2005 :  11:34:20  Show Profile  Visit AnonJr's Homepage
Yes, do post it up. I'm sure that more than a few people will come through looking for something like that.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07