that's a good idea, but VSS seems to think that the two sql scripts are binary files so it won't show the comparison.
Craig ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 2:08 PM Subject: Re: Database comparison software > 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
