Originally Posted by
earmsby
Ah great. That makes sense and much easier than poking through each menu trying to compare.
i love sql...
if you put your test configuration with the new values in a table called configuration_new, you can use something like this to find the changed values:
Code:
select cn.configuration_key, cn.configuration_value, c.configuration_value from configuration_new cn
left join configuration c
on cn.configuration_key = c.configuration_key
where cn.configuration_value <> c.configuration_value
of course you could just import the whole configuration table, but i'm not sure if there are values in your test side that you do not want.
Bookmarks