EnglishFrenchSpanish

OnWorks favicon

sqlt-diffp - Online in the Cloud

Run sqlt-diffp in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command sqlt-diffp that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

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=parser1 file_name2=parser2

Options:

-d|--debug Show debugging info
-t|--trace Turn on tracing for Parse::RecDescent
-c|--case-insensitive Compare tables/columns case-insensitively
--ignore-index-names Ignore index name differences
--ignore-constraint-names Ignore constraint name differences
--mysql_parser_version=<#####> Specify a target MySQL parser version
for dealing with /*! comments
--output-db=<Producer> This Producer will be used instead of one
corresponding to parser1 to format output
for new tables
--ignore-view-sql Ignore view SQL differences
--ignore-proc-sql Ignore procedure SQL differences
--no-batch-alters Do not clump multile alters to the same table into a
single ALTER TABLE statement where possible.
--quote=<character> Use <character> to quote all table and field
names in statements

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

· 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).

· 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>)] ;

· 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, CREATE, DROP statements are created by SQL::Translator::Producer::*, see there for
support/problems.

Currently (v0.0900), only MySQL is supported by this code.

Use sqlt-diffp online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    Image Downloader
    Image Downloader
    Crawl and download images using
    Selenium Using python3 and PyQt5.
    Supported Search Engine: Google, Bing,
    Baidu. Keywords input from the keyboard
    or input from ...
    Download Image Downloader
  • 2
    Eclipse Tomcat Plugin
    Eclipse Tomcat Plugin
    The Eclipse Tomcat Plugin provides
    simple integration of a tomcat servlet
    container for the development of java
    web applications. You can join us for
    discussio...
    Download Eclipse Tomcat Plugin
  • 3
    WebTorrent Desktop
    WebTorrent Desktop
    WebTorrent Desktop is for streaming
    torrents on Mac, Windows or Linux. It
    connects to both BitTorrent and
    WebTorrent peers. Now there's no
    need to wait for...
    Download WebTorrent Desktop
  • 4
    GenX
    GenX
    GenX is a scientific program to refine
    x-ray refelcetivity, neutron
    reflectivity and surface x-ray
    diffraction data using the differential
    evolution algorithm....
    Download GenX
  • 5
    pspp4windows
    pspp4windows
    PSPP is a program for statistical
    analysis of sampled data. It is a free
    replacement for the proprietary program
    SPSS. PSPP has both text-based and
    graphical us...
    Download pspp4windows
  • 6
    Git Extensions
    Git Extensions
    Git Extensions is a standalone UI tool
    for managing Git repositories. It also
    integrates with Windows Explorer and
    Microsoft Visual Studio
    (2015/2017/2019). Th...
    Download Git Extensions
  • More »

Linux commands

Ad