• From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Topic: FA 2.3.26 to FA 2.4.2+ DB Schema Synch

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.

Post's attachments

FA23_24_DBDiff.txt 7.1 kb, 14 downloads since 2017-10-28 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 629

Re: FA 2.3.26 to FA 2.4.2+ DB Schema Synch

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

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: FA 2.3.26 to FA 2.4.2+ DB Schema Synch

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.

Post's attachments

FA_23_to_24.sql 13.9 kb, 8 downloads since 2017-10-30 

You don't have the permssions to download the attachments of this post.

apmuthu's Website