Migration from 7.12.7 to 8.5.1 (SQL scripts for upgradit database schema)

šŸ“¦ Install & Upgrade Help
1

Hello,

I need to update database schema from 7.12.7 to 8.5.1 (or 8.6). But I cannot find SQL scripts in upgrade packages. Are these scripts available somewhere for download? :wink:

2

You could upgrade your database version as per compatibility matrix separately on your host server.

3

@rsp heā€™s not asking about upgrading MySQL, but about upgrading SuiteCRM in what pertains to the database schema (the structure of tables etc).

@davijana why would you want to do that instead of using the upgrade script itself? Itā€™s a quite complex upgrade, I donā€™t think you should attempt to do it ā€œmanuallyā€ unless you really know what youā€™re doing.

4

You are right, I donā€™t need to update MySQL (based on compatilibity matrix) ā€¦ I need to update database schema. Usually the update package contains SQL scripts which are responsible for this part of SuiteCRM update. But I canā€™t find these SQL scripts in update packages :frowning:

I understand, that the upgrade is a quite complex process. But I need to separate SQL update from this whole process and do it separately.

5
6

Hey @davijana

Have you gone through the steps in SuiteDocs - SuiteCRM 7.12.x+ migration to SuiteCRM 8.x?

On those, on step SuiteDocs - 2.6. Run the post upgrade command it tells you to run ./bin/console suitecrm:app:upgrade-finalize -t "<version>" which also runs migrationsā€¦ (like @pgr pointed out) which I assume that do the needed updates, other than the ones done by a Quick Repair and Rebuild.

This thread might also help: