Use Enterprise Manager to generate the SQL scripts for your
databases and then use a visual diff program to compare them. As long as
you use the option to generate one script file (instead of one for each
object) and choose the exact same options when generating both scripts, it
should be fairly straightforward.
Even if you do find a product that will do the comparison for you,
this is how it will go about it behind the scenes.
Eric A. Laney
Systems Architect
Verizon Security A species that enslaves other beings is hardly superior -- mentally
or
otherwise.
-- Kirk, "The Gamesters of Triskelion," stardate 3211.7.
Fregas <[EMAIL PROTECTED]>
11/19/2002 02:57 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: Database comparison software
Does anyone know of some kind of data structure comparison software? What
I need is something like Visual Source Safe but for databases. VSS has a
tool to compare two different versions of the same code/file and show
their differences. I would like to track down software that did this for
the schema of a database (we're using sql server currently.)
Any ideas?
Craig
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Get the mailserver that powers this list at http://www.coolfusion.com
