RE: compare schemas

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Mon, 19 Oct 2015 18:25:21 -0700 (PDT)
Message-ID: <3d84e814-7bee-402e-8f95-8defde01a8ea_at_default>

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_at_gmail.com] Sent: Monday, October 19, 2015 11:22 AM
To: lkemnitz_at_uwsa.edu
Cc: oracle-l_at_freelists.org
Subject: Re: compare schemas

Toad will do it.

On 19 October 2015 at 16:13, Leroy Kemnitz <lkemnitz_at_uwsa.edu> 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
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 20 2015 - 03:25:21 CEST