FarCry / MySQL Diff Utility

Currently running against #form.infoSchema#, run against another schema

 RENAME TABLE #application.dbowner#.#listLast(diff, "~")# TO #listFirst(diff, "~")#_temp , #application.dbowner#.#listLast(diff, "~")#_temp TO #listFirst(diff, "~")# ,

Dude...you gotta 'check' some diff's to fix :(

 SELECT table_name, table_type, engine FROM information_schema.tables WHERE table_schema = '#form.infoSchema#' ORDER BY table_name; SELECT 1 FROM #application.dbowner#.#k#

Findings for the #form.infoSchema# schema

From what we can see, FarCry thinks you have #lenTables# tables, MySQL currently has #qSchema.recordCount# tables.

MySQL

There is 1 tableare #listLen(lNotInDB)# tables missing from MySQL, maybe you need to head over to the coapi tool and see if you need to deploy anything?

Missing MySQL tables are that are referenced in FarCry:

  • #missing#
    •

FarCry

I can't find the following table references in FarCry (meaning they're in MySQL...but not FarCry), are they custom non-farcry tables? If so then you can ignore them.

  • #m#
    •

Case differences

We found some "case" differences between FarCry and mysql:

FarCry MySQL Fix
#stCompare[st]["farcry"]# #stCompare[st]["db"]#
Not found #stCompare[st]["db"]#  

* You need RENAME permissions for your database user for this to work.

Woo hoo!!! No case differences were found. Have a lovely day :)

Looks for differences in case between MySQL table names, and the relevant references in the FarCry coapi.
Also looks for missing tables in either FarCry or MySQL.

First we need the name of the actual MySQL project database, this is needed for a schema lookup.