Edwin
> Thanks for the reply. I had a look at xcase but it wasn't quite what i
> needed.
> I will explain a bit more..
>
> My problem is that I would like to obtain a list differences between 2
> databases in regards to the data definition.
> I have several databases which have been modified over a period of time.
> Certain ones work as they should with the app and
> others don't.
>
> 1 So my first problem is to work out why by finding out the differences
> between the 2 databases.
xCase does this - firstly you reverse engineer the working db into a model
and the synch this
with the non-working one - xcase will produce a 'change script'
>
> These databases contains triggers and stored procedures....
>
> 2 Does anybody know how to obtain trigger and stored procedures names and
> definitions from a interbase / SQL Server 7 database.
SQL is it in the sysobjects table (I'm not sure about Interbase) again xCase
will do this (for both)
> Another goal of mine, which is less important, is to compare 2 different
> databases of different vendors
> EG : A SQL Server Database with an Interbase Database. I realise the
trigger
> / stored procedure def. language is different.
> So maybe a tool exists which reverse engineers the database into a certain
> definition / modelling language.
> Once both databases have been imported it could do some sort of
comparision
> on it.
Little more difficult but basically you could reverse engineer both DB and
then
copy one model to another and compare - Elie Muyal (the xCase author) has
been going down the track
of an single model (with multiple targets) but there are so many variables
that it is almost impossible
Considering his tool reverses and synchs just about every SQL database he is
a fountain of knowledge
on extracting and maintaing metadata
Another way of approaching this (and very topical ) would be to export the
metadata to XML
for the 2 db's an do a comparison that way
xCase has TCL as a scripting language (which can get RO access to the
model - in fact the XML export is written
in TCL) so you could write your own model export routine and compare.
But it the log run you would be better of maintaining both your target
databases from a single model and
xCase can do this in a restricted sense.
>
> Has anybody else had this problem? If so how did you deal with it...
>
> Thanks guys..
>
> Edwin G. Das
> software developer
> exo-net e-business software
> an independent business division of Solution 6
>
>
> Tel: +64 9 366 0074
> Fax: +64 9 303 3357
> Web: www.exo-net.com
> Email: [EMAIL PROTECTED]
> ______________________________________
> INTERNET E-MAIL CONFIDENTIALITY CLAUSE
> The information contained in this document is CONFIDENTIAL and may also be
> LEGALLY PRIVILEGED and is intended only for the addressee. All comments
> made are without prejudice. If you are not the addressee, you are hereby
> notified that any use or dissemination of this information and the copying
> of the document is strictly prohibited. If you are not the addressee,
> please notify us immediately by phone on +64 9 366 0074.
> _________________________________________
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
