Thursday, March 22, 2012

Comparing data structure

Hi,
The task: we have to two databases. Both evolved from one root in ancient
times. Right now they differ quite a lot. We want to take them both back to
one. To prepare it we have to make some kind of report (no matter what kind

standalone program, excel sheet, Visio diagram) to aid “uniformization”.
One
DB is Oracle, other SQL Server. Both have hundreds of tables with tenths of
fields. Any ideas?
PS. Is it the right Group for this question? ;)
Regards,
MaKcheck out this link..
http://www.dbbalance.com/download.htm
I haven't tested this tool by myself. Is this what u wanted?
hope this helps
--
"MaK" wrote:

> Hi,
> The task: we have to two databases. Both evolved from one root in ancient
> times. Right now they differ quite a lot. We want to take them both back t
o
> one. To prepare it we have to make some kind of report (no matter what kin
d –
> standalone program, excel sheet, Visio diagram) to aid “uniformization
. One
> DB is Oracle, other SQL Server. Both have hundreds of tables with tenths o
f
> fields. Any ideas?
> PS. Is it the right Group for this question? ;)
> Regards,
> MaK

No comments:

Post a Comment