04, 2000 2:38 PM
To: Multiple recipients of list delphi
Subject: [DUG]: DB Comparision Question
Hi Neven
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
database
> 2 Does anybody know how to obtain trigger and stored procedures names and
> definitions from a interbase / SQL Server 7 database.
>
I don't know about interbase but you can get a list of stored procedures and
triggers from the sysobjects table in SQL Server. Stored procedures have
type = 'P' (a
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
> 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 ho
Hi Neven
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 perio
