Backup Sugar 4.2.0b and Importing into 4.5?

[ErikLindquist]

I was wondering if it was possible to backup the following elements of Sugar 4.2.0b and import them into Sugar 4.5b

• Accounts
• Contacts
• Opportunities
• Projects

I am running both versions of Sugar on

• Bitrocks stack
• MySQL
• Apache

Can I do a MySql dump and then import or are their new links between Accounts, Contacts, Opportunities and Projects that might be broken or left invalid?


Thanks,

Erik

[Markku]

Most likely that would not work.

Database structure is different between 4.2.0 and 4.50 plus there are dependencies between other tables.

You probably could compare db structure between these two versions and apply 4.5 changes manually to your existing 4.2.0 database, Just curious, why not to use upgrade wizard?

Best,

- Markku

[ErikLindquist]

Thanks Markku,

I created a separate 4.5 instance because I was having too many issues with 4.2.0b and also something broke when I installed the Objectives Module.

So I figured I would start fresh, fortunately we are only in a limited production use of 4.2, so even if people have to re-enter into 4.5 it won't be a major show stopper.

Perhaps export and import of Accounts, Contacts, Opportunities, and Projects will work?

Erik

[kpit]

you could use the export functionality in SugarCRM?

That might be a safer way to do it. Or use the SQL upgrade scripts in the patch file. then export the file with mysql dump.

But a small warning about moving the whole database. your troubles can follow you.