RE: compare schemas

  • From: Jeff Smith <jeff.d.smith@xxxxxxxxxx>
  • To: howard.latham@xxxxxxxxx, lkemnitz@xxxxxxxx
  • Date: Mon, 19 Oct 2015 18:25:21 -0700 (PDT)

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: