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

__________________
Wildfire Marketing Forum - Visit our free marketing forum to learn and share tips about marketing.

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...

__________________
Join the GreenStalk Quality Web Directory

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

__________________
Wildfire Marketing Forum - Visit our free marketing forum to learn and share tips about marketing.

possibly, I have never personally done it.

__________________
Join the GreenStalk Quality Web Directory

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

__________________
Indian SEO Company

abhishekmat, you mis-read the question

__________________
Wildfire Marketing Forum - Visit our free marketing forum to learn and share tips about marketing.

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

__________________
Rentals

and probably not worth the effort

__________________
Wildfire Marketing Forum - Visit our free marketing forum to learn and share tips about marketing.

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...

__________________
Designer Banners | The Ultimate BMW Blog!

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

__________________
PR6 Sublime Directory Lyrics