Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update documentation for the sqldiff tool to include the --vtab option. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0e6ed0fa488ac2b98a2e5ee511456c57 |
User & Date: | dan 2016-08-25 19:50:05.191 |
Context
2016-08-27
| ||
23:54 | Use < instead of < in the r-tree documentation. (check-in: a55027b452 user: drh tags: trunk) | |
2016-08-25
| ||
20:47 | Merge trunk changes into this branch. (check-in: a3888fbe0e user: dan tags: experimental) | |
19:50 | Update documentation for the sqldiff tool to include the --vtab option. (check-in: 0e6ed0fa48 user: dan tags: trunk) | |
2016-08-17
| ||
12:01 | In althttpd.c, increase the default maximum content size to 250MB. (check-in: f65bebb25e user: drh tags: trunk) | |
Changes
Changes to pages/sqldiff.in.
1 2 | <title>sqldiff.exe: Database Difference Utility</title> <tcl>hd_keywords sqldiff sqldiff.exe</tcl> | | > > | | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | <title>sqldiff.exe: Database Difference Utility</title> <tcl>hd_keywords sqldiff sqldiff.exe</tcl> <table_of_contents> <h1>Usage</h1> <p> The <tt>sqldiff.exe</tt> binary is a command-line utility program that displays the differences between SQLite databases. Example usage: <codeblock> sqldiff [options] database1.sqlite database2.sqlite </codeblock> <p> The usual output is an SQL script that will transform database1.sqlite (the "source" database) into database2.sqlite (the "destination" database). This behavior can be altered using command-line switches: <dl> <dt><b>--changeset FILE</b></dt> <dd><p>Do not write changes to standard output. Instead, write a (binary) |
︙ | ︙ | |||
37 38 39 40 41 42 43 44 45 | <dd><p>Show how many rows have changed on each table, but do not show the actual chagnes</dd> <dt><b>--table TABLE</b></dt> <dd><p>Show only the differences in content for TABLE, not for the entire database</p></dd> <dt><b>--transaction</b></dt> <dd><p>Wrap SQL output in a single large transaction</p></dd> </dl> | > > > > | | | | | > > > > > > > > > > > > > > > > > | 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 | <dd><p>Show how many rows have changed on each table, but do not show the actual chagnes</dd> <dt><b>--table TABLE</b></dt> <dd><p>Show only the differences in content for TABLE, not for the entire database</p></dd> <dt><b>--transaction</b></dt> <dd><p>Wrap SQL output in a single large transaction</p></dd> <dt><b>--vtab</b></dt> <dd><p>Add support for handling [FTS3], [FTS5] and [rtree] virtual tables. <a href=#vtab>See below</a> for details. </p></dd> </dl> <h1>How It Works</h1> <p>The sqldiff.exe utility works by finding rows in the source and destination that are logical "pairs". The default behavior is to treat two rows as pairs if they are in tables with the same name and they have the same [rowid], or in the case of a [WITHOUT ROWID] table if they have the same [PRIMARY KEY]. Any differences in the content of paired rows are output as UPDATEs. Rows in the source database that could not be paired are output as DELETEs. Rows in the destination database that could not be paired are output as INSERTs. <p>The --primarykey flag changes the pairing algorithm slightly so that the schema-declared [PRIMARY KEY] is always used for pairing, even on tables that have a [rowid]. This is often a better choice for finding differences, however it can lead to missed differences in the case of rows that have one or more PRIMARY KEY columns set to NULL.</p> <h1>Limitations</h1> <ol> <li> <p>The sqldiff.exe utility is unable to compute differences for rowid tables for which the rowid is inaccessible. An example of a table with an inaccessible rowid is: <codeblock> CREATE TABLE inaccessible_rowid( "rowid" TEXT, "oid" TEXT, "_rowid_" TEXT ); </codeblock> <li><p> The sqldiff.exe utility does not (currently) display differences in [CREATE TRIGGER|TRIGGERs] or [CREATE VIEW|VIEWs]. <li><p id=vtab> By default, differences in the schema or content of virtual tables are not reported on. <p>However, if a [virtual table] implementation creates real tables (sometimes refered to as "shadow" tables) within the database to store its data in, then sqldiff.exe does calculate the difference between these. This can have surprising effects if the resulting SQL script is then run on a database that is not <i>exactly</i> the same as the source database. For several of SQLite's bundled virtual tables (FTS3, FTS5, rtree and others), the surprising effects may include corruption of the virtual table content. <p> If the --vtab option is passed to sqldiff.exe, then it ignores all underlying shadow tables belonging to an FTS3, FTS5 or rtree virtual table and instead includes the virtual table differences directly. </ol> |