Difference between revisions of "COMPARE DATABASE"
Yvonne.milne (Talk | contribs) (→See Also) |
Yvonne.milne (Talk | contribs) (→Example) |
||
| Line 17: | Line 17: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | compare database | + | // The 'production' database has been deployed to the server. |
| − | compare database | + | // On the development system the 'production' database |
| + | // has been copied to 'production_live'. | ||
| + | // Development continues and changes have been made to | ||
| + | // the development 'production' database. | ||
| + | // The following can be used to produce upgrade scripts | ||
| + | // to update the 'production' database on the server. | ||
| + | compare database production with production_live to file upgrade.prg | ||
| + | compare database production with production_live table customers to file upgrade.prg | ||
</code> | </code> | ||
Revision as of 13:30, 16 November 2020
Contents
Purpose
Compares two databases and optionally creates an upgrade Lianja/VFP script
Syntax
COMPARE DATABASE <databasename1> WITH <databasename2> [TABLE <tablename> ] [TO FILE <filename.prg>]
See Also
ADATABASES(), ADD TABLE, ALTER INDEX, ALTER TABLE, CHECK DATABASE, CHECK TABLE, CLOSE DATABASES, CLOSE TABLES, COMPARE TABLE, COMPILE DATABASE, COPY DATABASE, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE VIEW, DATABASE(), DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY SCHEMAS, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), INDEX, Lianja Package Files, Lianja Package Manager, LIST DATABASE, LIST INDEXES, LIST SCHEMAS, LIST TABLES, OPEN DATABASE, PACK, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET AUTOCATALOG, SET EXCLUSIVE, USE
Description
The COMPARE DATABASE command compares two databases, <databasename1> and <databasename2>, and optionally generates an upgrade script, <filename.prg>, that can be packaged up and uploaded to a live system. A script named upgrade.prg (compiled to upgrade.dbo) is automatically detected and installed by the Lianja Cloud Server without requiring any machine downtime when included in a deployed Lianja Package File.
By default, all tables in <databasename1> are compared, along with the database metadata, stored procedures and events. If the optional TABLE <tablename> clause is included, only the specified table is compared (and the database metadata, stored procedures and events).
Individual tables can also be compared using the COMPARE TABLE command.
Example
// The 'production' database has been deployed to the server. // On the development system the 'production' database // has been copied to 'production_live'. // Development continues and changes have been made to // the development 'production' database. // The following can be used to produce upgrade scripts // to update the 'production' database on the server. compare database production with production_live to file upgrade.prg compare database production with production_live table customers to file upgrade.prg
