Compare Schema classes to database
phil at pgpotter.co.uk
Thu Sep 15 21:37:11 UTC 2022
We have code in our software, which looks for schema changes compared to
the SQL database, so that it can modify the database and keep it up to
date with the current library schemas layout...
For starters you can use this Omnis command to fetch the SQL tables on
and then for columns within that table:
From this information, you can compare your internal schemas, with
those held on the database.
If you need to go further and check each column matches the format
within the Omnis Schema
Will provide you with the matching format your schema would create upon
So you can then compare column by column for changes.
I believe these are standard DAM methods, so should work with most, if
not all SQL back ends.
On 15/09/2022 17:39, Andrew Stolarz wrote:
> Hi All,
> Is there an easy way to compare my Schema classes in Omnis to my MySQL
> Anyone else do something like this?
> Manage your list subscriptions athttps://lists.omnis-dev.com
> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en