> 1 So my first problem is to work out why by finding out the differences
> between the 2 databases.
why not keep your design in something like S-Designer and use its archive
feature to get the difference...
> 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.
RDB$PROCEDURES and RDB$TRIGGERS I think.
>
> 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.
You should be able to compare the field names, but I'd guess you would have
to write your own app to do it.
> So maybe a tool exists which reverse engineers the database into a certain
> definition / modelling language.
S-Designer does, I'd imagine that ERwin and co do too. www.seagate.com for
s-designer, its part (kinda) of powerbuilder.
> Once both databases have been imported it could do some sort of
> comparision
> on it.
>
> Has anybody else had this problem? If so how did you deal with it...
Can't say I have - I've not had to change the metadata of a running DB
yet,... _yet_.
:)
N
---------------------------------------------------------------------------
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"
