Web Wiz Forums - import database into another

Print Page | Close Window

import database into another

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=11908
Printed Date: 09 April 2026 at 3:04am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: import database into another

Posted By: asp_guy
Subject: import database into another
Date Posted: 22 September 2004 at 8:37pm

I want to import data from a webwiz forum database version 7.5 into another working forum of version 7.8 without losing data from any of them.

I hope u get my point. It is not just an upgrade. I need to merge the data of both databases.

thanx in advance

Replies:

Posted By: michael
Date Posted: 23 September 2004 at 9:17am

it will make it a tad difficult but is doable, there are different merge approaches one is i.e. you remove primary key from the 7.5 database, make it a normal into field, then in every table that had a pk just add (max primary key of 7.8 + 1) to it so there will be no pk clash in the final result. After you did that you can just use dts for sql or copy paste in access for all tables you want to merge. for the forums itself be careful that you update topics and posts to look at the right forum once you changed the pk.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker