Web Wiz Forums - Merge two forum databases

Print Page | Close Window

Merge two forum databases

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30400
Printed Date: 29 March 2026 at 4:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Merge two forum databases

Posted By: dbramley
Subject: Merge two forum databases
Date Posted: 11 July 2012 at 1:52pm

Hi,

I host with Webwiz and have a couple of sites using webwiz forums too. Each site currently has its own SQL database but each site also has a different table prefix.

I have created a brand new MSQL database and would like to merge my existing three databases into this. I can't seem to work out how to do it? A restore simply replaces the previous one each time.

Any suggestions?

Thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 11 July 2012 at 4:34pm

This would be a very complex task to do and would require a good knowledge of SQL Server Databases.

The data from the other databases would need to be imported in to the database, but this would drop much of the database schema such as default values, primary keys, foreign keys, indexes, etc. that would need to be manually rebuilt.

I am a developer on Web Wiz Forums and even with my knowledge of the database schema this tasks to merge 3 forums in to 1 database would take the best part of a day to complete correctly.

If the forums are large, or could become large I would not suggest using a single database as this could impact on performance.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting