Merging Databases

Ok, does any1 know how to merge databases? If so can you explain what to do?

Reason, I am switching from extdb to extdb2 and v1.2 but I don't want my players to lose everything.

Please Post walkthrough link or walkthrough.

You don't need to merge, should work 100%

just swap out the 2.03 db with 2.04? and all will work? obviously with all the other files.

I did the following ...

Export MySQL db to sql file
Create new database using 2.04 schema
Make custom sql changes
Update the exported sql file with any issues ( case sensitive table names and remove drop / create table statements )
Use a tool like navicat to import the sql into the new database
Make sure all dlls, ini and extDB connection configs are updated.
Make sure your main_config.sqf is updated

Enjoy the benefits of 1.2 !


Edit: you may need to run that jpgtopaa.sql which changes all your saved texture names to .paa as they were all converted in 1.2

Never used Navicat, I use wampserver and phpmyadmin.

Why? Just backup your DB. Upgrade to 2.04, run the extra sql file for jpg > paa and youre done.

I think I derp'd or something

http://forums.a3wasteland.com/index.php?topic=2061.0