Database Merging:

[krispy1812]

Is there an easy way to merge two (VB) databases together ?
I have phpmyadmin access, but simply doing a dump of the data straight into the database can cause problems, I was wondering if there was a smoother way of doing it.
I know you have the impex, but can it be used to merge two vb databases ? If not, what would work.

thanx

[Wayne Luke]

You can use Impex to import one database into another. It is probably the easiest and safest way to deal with unique keys and auto-incrementing primaries.

[Zachery]

What exactly is your end goal in mergeing the two forums? Are you trying to avoid an upgrade or is this a merger of sorts?

[krispy1812]

Hi,

Yes it is just more or less a merger. Moving my database into someone else's, but they don't know what to do, so I was more or less going to do it for them.

It was basically just looking at joining the two site's databases, they are both vb.

I did read an article when I did a search prior to it, that someone tried using the impex for something similar but it overwrote their existing data (alhtough I understand the problem was that he had run the program twice and not read the 'after import' guide).

I'll read the guide and associated pages, and if I have problems I'll post back.

thanx