Be sure you aren't generating your scripts in Unicode.
Eric A. Laney
Systems Architect
Verizon Security "Speak softly... and carry a big stick."
-- Theodore Roosevelt
Fregas <[EMAIL PROTECTED]>
11/19/2002 03:37 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
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
