Documentation Source Text

Check-in [2924043d8c]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add support for the --lib option on sqldiff.exe.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2924043d8c832dd293f54d66ca34c496d67c153e
User & Date: drh 2015-05-04 13:26:17.188
Context
2015-05-04
21:13
Add documentation on the dbstat virtual table. (check-in: 2ea5a64156 user: drh tags: trunk)
13:26
Add support for the --lib option on sqldiff.exe. (check-in: 2924043d8c user: drh tags: trunk)
12:16
Add the matchinfo(..,'y') option addition to the change log. (check-in: 0cd02758ec user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/sqldiff.in.
︙︙
18
19
20
21
22
23
24





25
26
27
28
29
30
31

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)
       changeset file into FILE.  The changeset can be interpreted using
       the sessions extension to SQLite.</dd>





<dt><b>--primarykey</b></dt>
<dd><p>Use the schema-defined [PRIMARY KEY] instead of the [rowid] to
       pair rows in the source and destination database.  (See additional
       explanation below.)</dd>
<dt><b>--schema</b></dt>
<dd><p>Show only differences in the schema not the table content</p></dd>
<dt><b>--summary</b></dt>








>
>
>
>
>








18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

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)
       changeset file into FILE.  The changeset can be interpreted using
       the sessions extension to SQLite.</dd>
<dt><b>--lib LIBRARY</b></dt>
<dt><b>-L LIBRARY</b></dt>
<dd><p>Load the shared library or DLL file LIBRARY into SQLite prior to
       computing the differences.  This can be used to add application-defined
       [collating sequences] that are required by the schema.
<dt><b>--primarykey</b></dt>
<dd><p>Use the schema-defined [PRIMARY KEY] instead of the [rowid] to
       pair rows in the source and destination database.  (See additional
       explanation below.)</dd>
<dt><b>--schema</b></dt>
<dd><p>Show only differences in the schema not the table content</p></dd>
<dt><b>--summary</b></dt>
︙︙
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81

CREATE TABLE inaccessible_rowid(
   "rowid" TEXT,
   "oid" TEXT,
   "_rowid_" TEXT
);
</pre></blockquote>

<li><p>
Differences cannot be computed for tables that use application-defined
[collating sequences] since sqldiff.exe will be unable to compare values.

<li><p>
The sqldiff.exe utility does not (currently) display differences in
[CREATE TRIGGER|TRIGGERs], [CREATE VIEW|VIEWs], or [virtual tables].
</ol>








<
<
<
<





72
73
74
75
76
77
78




79
80
81
82

CREATE TABLE inaccessible_rowid(
   "rowid" TEXT,
   "oid" TEXT,
   "_rowid_" TEXT
);
</pre></blockquote>





<li><p>
The sqldiff.exe utility does not (currently) display differences in
[CREATE TRIGGER|TRIGGERs], [CREATE VIEW|VIEWs], or [virtual tables].
</ol>