FrontAccounting forum — FA 2.3.26 to FA 2.4.2+ DB Schema Synch

Re: FA 2.3.26 to FA 2.4.2+ DB Schema Synch

null@example.com (apmuthu) — Mon, 30 Oct 2017 14:27:14 +0000

This tool misses out on CHAR to VARCHAR conversions and some other small constructs, but yes, it is a quick and dirty fix.

Attached is the SQLyog output for the same FA 2.3 to 2.4 official diff.

Re: FA 2.3.26 to FA 2.4.2+ DB Schema Synch

null@example.com (poncho1234) — Sat, 28 Oct 2017 23:14:39 +0000

That's a useful tool...its in my bookmarks now.

FA 2.3.26 to FA 2.4.2+ DB Schema Synch

null@example.com (apmuthu) — Sat, 28 Oct 2017 22:43:40 +0000

The sql/alter2.4*.php files are there to migrate the data into the new fields/tables and the FA web user interface is the correct way to upgrade an FA install.

To compare the standard chart differences and sql statements needed to synch the database from FA v2.3 to FA v2.4 we can use the online tool at http://www.infoom.se/compare-mysql-online/ by pasting the FA 2.4.2+ sql/en_US-new.sql's contents in the upper textbox and that of the FA 2.3.x counterpart in the lower textbox and click "Compare".

Attached is the current state.