Merging two databases.

Jerlene · 06-06-2007, 10:59 PM

I have two databases. See screenshot below for better explanation.

I want database one to be merged into database two and have database two be the main database with all information in it so I can get rid of database one.

How do I go about doing this?

monaco · 06-06-2007, 11:21 PM

export one of them and exclude any autogenerated/incremented identity fields. Then just import it into the other one. They both appear to be phpbb tables, so the schema should be identical, if not very similar.

Peter · 06-06-2007, 11:47 PM

if they are both phpbb tables it is not going to be that easy. The auto increment fields that you mention are used to distinguish who posted what for example and who pm's are who's.

If you simply merge them ignoring the auto increment then the members on the original database will suddenly be credited for more posts than they posted and will have m's not intended for them.

Another potential problem is if 1 database has extra fields etc (maybe for mods or for some other reason).

06-06-2007, 10:59 PM	THREAD STARTER #1 (permalink)
Jerlene NamePros Regular Join Date: Mar 2006 Location: LifesCircle.info Posts: 954 Follow @LifesCircleInfo	Merging two databases. I have two databases. See screenshot below for better explanation. I want database one to be merged into database two and have database two be the main database with all information in it so I can get rid of database one. How do I go about doing this? __________________ Buy Backlinks

06-06-2007, 11:21 PM	#2 (permalink)
monaco NamePros Regular Join Date: Jul 2005 Location: Tucson, AZ Posts: 689	export one of them and exclude any autogenerated/incremented identity fields. Then just import it into the other one. They both appear to be phpbb tables, so the schema should be identical, if not very similar. __________________ My Website \| My Blog

06-06-2007, 11:47 PM	#3 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,074	if they are both phpbb tables it is not going to be that easy. The auto increment fields that you mention are used to distinguish who posted what for example and who pm's are who's. If you simply merge them ignoring the auto increment then the members on the original database will suddenly be credited for more posts than they posted and will have m's not intended for them. Another potential problem is if 1 database has extra fields etc (maybe for mods or for some other reason).

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)