SQLT-DIFF-OLD(1p) User Contributed Perl Documentation SQLT-DIFF-OLD(1p)NAME
sqlt-diff - find the differences b/w two schemas
SYNOPSIS
For help:
sqlt-diff -h|--help
For a list of all valid parsers:
sqlt -l|--list
To diff two schemas:
sqlt-diff [options] file_name1=parser file_name2=parser
Options:
-d|--debug Show debugging info
DESCRIPTION
sqlt-diff is a utility for creating a file of SQL commands necessary to transform the first schema provided to the second. While not yet
exhaustive in its ability to mutate the entire schema, it will report the following
o New tables
Using the Producer class of the target (second) schema, any tables missing in the first schema will be generated in their entirety
(fields, constraints, indices).
o Missing/altered fields
Any fields missing or altered between the two schemas will be reported as:
ALTER TABLE <table_name>
[DROP <field_name>]
[CHANGE <field_name> <datatype> (<size>)] ;
o Missing/altered indices
Any indices missing or of a different type or on different fields will be indicated. Indices that should be dropped will be reported
as such:
DROP INDEX <index_name> ON <table_name> ;
An index of a different type or on different fields will be reported as a new index as such:
CREATE [<index_type>] INDEX [<index_name>] ON <table_name>
( <field_name>[,<field_name>] ) ;
"ALTER/DROP TABLE" and "CREATE INDEX" statements are not generated by the Producer, unfortunately, and may require massaging before being
passed to your target database.
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
SEE ALSO
SQL::Translator, <http://sqlfairy.sourceforge.net>.
perl v5.14.2 2012-01-18 SQLT-DIFF-OLD(1p)
Check Out this Related Man Page
DROP SCHEMA(7) SQL Commands DROP SCHEMA(7)NAME
DROP SCHEMA - remove a schema
SYNOPSIS
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP SCHEMA removes schemas from the database.
A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even
if he does not own some of the objects within the schema.
PARAMETERS
IF EXISTS
Do not throw an error if the schema does not exist. A notice is issued in this case.
name The name of a schema.
CASCADE
Automatically drop objects (tables, functions, etc.) that are contained in the schema.
RESTRICT
Refuse to drop the schema if it contains any objects. This is the default.
EXAMPLES
To remove schema mystuff from the database, along with everything it contains:
DROP SCHEMA mystuff CASCADE;
COMPATIBILITY
DROP SCHEMA is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart
from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER SCHEMA [alter_schema(7)], CREATE SCHEMA [create_schema(7)]
SQL - Language Statements 2010-05-14 DROP SCHEMA(7)
Hello is there a way to limit the number of lines output by the DIFF command?
I tried -C 200 ect and -c but it continues to print out the whole huge file.
Reason needed is i'm trying to do alot of DIFFs on a long list of files and would like to only get back an indicator which files are... (2 Replies)
Hey,
I am running a linux shell script containing some php. I want to be able to do a DIFF on two files...if the files are identical, set an exit status of 0, and if they are different, set an exit status of 1.
I have been looking long and hard on how to do this, but I don't think that I... (3 Replies)
Suppose u have a file
FILE A
ABCA10 DIFF VALUES P203S POLY
ABCA1 DIFF VALUES A1046D
ABCA4 DIFF VALUES D846H POLY
ABCA4 DIFF VALUES I1846T POLY
ABCA4 DIFF VALUES Wa
ABCA4 DIFF VALUES WA
ABCA4 DIFF VALUES Wb
and u want to print that if FILE A have POLY so print 0 otherwise 1
means... (1 Reply)
Hi,
i want to extract the 'CREATE INDEX' or 'CREATE UNIQUE INDEX' statements from a ddl file and output each match to a separate file. i was looking around the net but couldnīt find anything.
a possible sed-script could be:
sed -n '/CREATE*INDEX*/,/COMMIT/p' filename.ddlbut i couldnīt find out... (11 Replies)
In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one.
But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
I have file like this
"copy table_name from filea.txt on node replace delimiter '|';"
"copy table_name from fileb.txt on node replace delimiter '|';"
"copy table_name from filec.txt on node replace delimiter'|';"
"copy table_name from filee.txt on node replace delimiter '|';"
"copy... (1 Reply)
HI All,
I am new to Unix shell scripts..
Could you please post the unix shell script for for the below request.,
There are two different tables(sample1, sample2) in different schemas(s_schema1, s_schema2).
Unix shell script to compare the columns of two different tables of two... (2 Replies)
Hello friends,
There is one requirment where I need to login into database environment and pull all schema names into a text file ...
as of now below are the schemas available...
$> describe keyspaces;
system_schema system_auth system abc system_distributed system_traces
Now from... (4 Replies)