Board index » delphi » data dictionary / metadata

2006-05-10 02:41:56 AM
delphi251
For our (file based) database applications we use to have some sort of data
dictionary witch was distributed with our products. At client-side the
meta-data was compared to the client-database and if there where changes in
the datamodel the meta-engine took care of the modification of the database
(without the loss of data).
We do consider migrating these applications to one of the available
client-server-SQL-databases like MS SQL.
Wich tools do you recommend to manage our datamodel and client-data ?
--
XSO; xBase Software Ontwikkeling BV
Lytsedyk 16, NL 9036 ML Menaldum
Tel: +31 (0)518 452408
Fax: +31 (0)518 452039
Email XXXX@XXXXX.COM
Internet: www.xso.nl
 

Please take a look at our Context Database Extensions & Designer.
It does what you need and more. Particularly, it can manage
meta-data, produce SQL scripts for updates, track changes
between versions of database schema and apply updates to client
databases at run-time.
Data dictionary is implemented as TDatabaseSchema component, which
you can use in your Delphi application. Database Designer is
called when you double click it. You can rev.eng databases, SQL
scripts, produce diagrams, etc.
We've just released a new version today.
Supports MS SQL, Oracle, Mimer, DBISAM, Nexus and more to come.
www.contextsoft.com/products/ctxdbext
also see the designer here (comes with extensions):
www.contextsoft.com/products/dbdesign
Sincerely,
Michael
Rinse Lemstra writes:

Take a look at Database Comparer (standalone and vcl versions) from
www.clevercomponents.com. I haven't tried them yet, maybe you can be my
guinea pig :)
 

As a Delphi Developer of the Context Database Designer, I can not recommend it
highly enough. Support is better than first class. And no, I have no
affiliation with the authors of said same above.
Cheers,
GW.
www.contextsoft.com
"Rinse Lemstra" <XXXX@XXXXX.COM>writes