the structure use the DataBee tool to
copy the structure from prod to test.
Yechiel AdarMehish
- Original Message -
From:
Cupp Michael E Contr Det 1
AFRL/WSI
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 13, 2003 9:59
PM
Subject: Database Compare
--_=_NextPart_001_01C3AAA8.95C529E0
Content-Type: text/plain; charset=iso-8859-1
Well, I have to say the answer to both questions is probably DataBee . (
www.databee.com http://www.databee.com ) , although not via a script.
Just been using it quite a bit recently, so your question
Hi
Check out the free tool on http://www.impacttoys.com. It is called
T.O.Y.S. and compares the schema's or complete database between two
databases. You can specify down to the object levels what is compared
and also generate DDL to synchronise the two. Its windows GUI based and
seems quite
Here are the requirements for toys:
Microsoft® Windows® XP / 2000 / NT4 / Me* / 98*
Do you know af any tool that doesn't require obscene operating systems?
(Obscene OSes = the ones above, plus anything from the same vendor)
At least, it should work under Wine.
On 11/14/2003 12:09:27 PM, Pete
I am looking for a script to compare an entire database
instance against another. (From [EMAIL PROTECTED], etc).
I do not want something that has to be done by schema, as I
have 50+ schema's to compare.
ALSO - on a side note, is there an 'easy'
way of duplicating a PRODUCTION
-
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Saturday, May 12, 2001 12:20
AM
Subject: DATABASE COMPARE SCRIPT
I am
trying to find out the schema differences between two databases.
Differences like Column size,column datatype,column data
--Boundary-00=_TI6B0KP3KE5T3HEN611V
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 8bit
The database compare script didn't come out to well the first
time, so I've just embedded them in this post.
The scripts are:
clears.sql
columns.sql
title.sql
Title: RE: When to go for ORACLE NAMES Server
I am
trying to find out the schema differences between two databases.
Differences like Column size,column datatype,column data length,
indexes,tables,constraints etc.
If
anyone has a script or know where I can get one that will accomplish this,
--Boundary-00=_I6J7K4TVKE7DS65S6BN5
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Perhaps this will help.
If the attachments don't go through, I will resend
as part of the message.
FYI I haven't used the schema_diff.sql script in awhile, but
it
