Dear Developers (anybody, not only support)!

We working in team, and now we used SVN for our projects.

For Delphi files this is ideal, because everything is text based, and we can compare the differents.

But now we "bumped" into problem of the database, because it is binary coded.

Two case when database changed:
1.) Metadata, structure changed.
2.) Data changed.

Data changes are not interesting for us, only metadata changes.
The problem that in SVN we cannot determine, which happened.
If something(!) changed, the SVN try to commit changed files.

But real case was that I changed a table data, the team changed the table structure; and this is lost, because I post my changes later...

This is not too easy operation:
1.) I detect that something changed in EDB DataBase, different as in my local repository.
2.) I need to checkout full DB to temp directory.
3.) I open EDBManager.
4.) I open my DB
5.) I open temp DB
6.) I create structure SQL about both DBs
7.) I open WinMerge and compare them...
8.) Possible after this I recognize that only record changed, not the structure...

Do you know better way to do this?
Or can I automatize reverse enginering (other things I can automatize)?

Please help me, because if this not possible, I must create a tool to push system tables to XML for each DBs - to I can compare the differents...

May this description not understandable...
But the meaning of it: compare databases quickly for team work, from script if possible!

Thanks:
  dd

durumdara wrote:

<<<We working in team, and now we used SVN for our projects.>>>

Now we found a way for this:

- In svn repository we have the last version
- I checkout it to a directory.
- This directory mapped under EDBManager's session.
- I open this
- I open the original DB
- I backup the original DB
- I make Rev. Eng. with Upgrade (source: svn last, dest: original db).
- If they are same, there is nothing to do
- If not, I can see, what changed; and what is that I make after last modifications
- I cut these modifications (are never than in repos.)
- I run the script
- If everything is good, I smiling. If not, Restore the backup

But may you have easier method to do is. If it is exists, please tell us...

Thanks: dd