http://www.fileware.co.uk/ I use filesync for dev/prod syncs. I also use the binary compare to ignore timestamp differences. @ $15, well worth it.
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: Fregas [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, November 19, 2002 2:37 PM >>To: SQL >>Subject: Re: Database comparison software >> >>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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
