Building on this idea, I would think that it would not be too difficult to write something(either t-sql, cf, or whichever language you prefer) that hits sysobjects and bounces the two schemas off of each other. There might be some issues accessing the system tables across sql servers but they should be workable.
Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, November 19, 2002 2:08 PM >>To: SQL >>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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
