actionwave34F
Member
Recently when integrating fabrik to production sites we have problems to detect changed tables (we have a lot of tables). Here is a neat SQL script to detect updates. Then you can jump unto backend forms and use "update database" for the tables that must be updated.
select table_name, column_name
from information_schema.columns
where table_schema IN ('source schema','target schema')
group
by column_name
having count(*) = 1
order
by column_name
;
select table_name, column_name
from information_schema.columns
where table_schema IN ('source schema','target schema')
group
by column_name
having count(*) = 1
order
by column_name
;