merging 2 databases

[jlknauff]

Is it possible to merge 2 sql databases without ruining them?

[wlh]

sure, I think its called 'table join' or 'left table join' command which will create a brand new table with both database information. Hope that helps...

[jlknauff]

so could I merge the databases from 2 phpBB boards and keep everything intact? I'm sure there would be a lot of clean up after though :s&m:

[wlh]

possibly, I have never personally done it.

[abhishekmat]

Yes 8-| From MS Access to SQL .
For that your computer must have SQL server installed.

[jlknauff]

abhishekmat, you mis-read the question ;)

[Cyber-SEO]

Here is a few things you can try.

If your using sql2k then you can use the sql tool which comes with Enterprise Manager. You can use the tool to import the stuff from the other db (I have never done this to merge to DB's b but it might just work) you may want to test it out by making a few copies of the two db's.

Now the problem you will have there is the record ID's are the same and in most cases these id's MUST be unique since they are primary keys.

So the best thing to do is to make a custom merge tool where you can merge to two db's but assigning new id's to the stuff that is being imported. Now there you will have other issues such as if you are merging a forum the thread id's are assigned to user id's and since you will have to create new user id's from yoru merging DB you will have to make sure you change the ID's of the threads and posts and ETC, ETC.

Basically it would be a very complicating process which in the end would take up LOADS of time ;)

[jlknauff]

and probably not worth the effort

[daboss]

you want to merge 2 similar databases into 1? e.g. 2 vbulletin databases (same schemas) into a single vbulletin database?

if so, it'll be tough job - but very possible. i've done something like this before (not vbulletin) for a project at work - a lot of analysis required to make sure unique keys remain unique by changing the keys of one set of data...

[l234244]

Is there no way you can set up an rss feed from one forum to the other?

[jlknauff]

[QUOTE=daboss]you want to merge 2 similar databases into 1? e.g. 2 vbulletin databases (same schemas) into a single vbulletin database?[/QUOTE]
Yes, but that was a while ago. Not worried about it anymore ;)