| |
Deployment options allow you to change how the "Schema" database procedures will
create or modify the "Data" database. Options can be changed for:
Check constraints Foreign key constraints Created time stamps Updated time stamps Target ("Data") database
In practice, if the "Data" database is not more than a few gigabytes and the
traffic on the site does not exceed 500,000 pageviews a day, there is no need to disable
any of the options.
The main window menu provides several deployment
commands:
Recreate All - will recreate all "Data" database including
tables and stored procedures.
This option will erase all the data. Recreate procs - recreates all stored procedures.
Safe operation, no data will be lost. Recommended when the only change in the schema
is the order of properties. Update properties - needed when datatype of any property or the range of values
are changed. No data will be lost. If existing data cannot be converted to the new format,
the schema will revert to previous state. When properties are updated, run Recreate procs
as well. Update Class - updates selected class individually. This option will erase
existing data for the selected class and recreate the class' table(s), constraints, indexes and
related stored procedures. If you need to preserve the data, dump it to a temporary table(s)
and then restore to the recreated table(s). In the future versions of DB3NF we plan to do this automatically.
|
