RE: compare schemas
- From: "Powell, Mark" <mark.powell2@xxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Oct 2015 13:21:46 +0000
we don’t do DROP's out-of-the-box because...bad things people do with tools
w/o thinking. <<
Agree. I prefer to include DROP statements as a comment. A little editing to
make the drop effective is usually not that difficult to apply.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [
mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jeff Smith
Sent: Monday, October 19, 2015 9:25 PM
To: howard.latham@xxxxxxxxx; lkemnitz@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: compare schemas
SQL Developer Data Modeler will do that. I posted a how-to on my blog today on
how to get your ALTER SCRIPTS with DROPs included.
For what it's worth, we don’t do DROP's out-of-the-box because...bad things
people do with tools w/o thinking.
Jeff
-----Original Message-----
From: Howard Latham [
mailto:howard.latham@xxxxxxxxx]
Sent: Monday, October 19, 2015 11:22 AM
To: lkemnitz@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: compare schemas
Toad will do it.
On 19 October 2015 at 16:13, Leroy Kemnitz <lkemnitz@xxxxxxxx> wrote:
I am working in SQL developer 4.0. I am comparing my acceptance
version of a schema to my production version of the same schema. We
did some ‘clean-up’ of old tables and views in acceptance. We want to
apply the same changes to production, when we go to prod. How do I
tell SQL D to produce a ‘drop’ statement when running a diff and doing the
compare?
LeRoy
----------------------------------
LeRoy Kemnitz
Oracle Database Administrator
UW System Administration
Phone: (608) 265 -5775
Fax: (608) 265 - 2090
--
Howard A. Latham
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: