Take any tool that does compare schema, trace it, and put
a wrapper that will activate the script for all schemas in the
database.
If you have TOAD you can easily capture the sql via spool
sql to file (or screen).
For your side note: restore a backup to the test
system.
If you need only
--_=_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
Title: RE: When to go for ORACLE NAMES Server
-- DATATYPE.sql
--
-- To check datatype consistency between two environments
--
--
SELECT
table_name,
column_name,
data_type,
data_length,
data_precision,
data_scale,
nullable
FROM
--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
--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