Archives
They are not stated in Syteline manual, but from my experience, I would suggest the following routine after upgrade a Syteline DB. 1) Regenerate _all table, by using “Update _All Tables” form. 2) Regenerate trigger, by using “Trigger management” form. 3) Regenerate Replication Triggers, if you are using multi-site replication. 4) Drop all the _tt […]
Jul 6th, 2014 | Filed under Application, Development
In the SyteLine database you will find Temporary tables that start with: tt_* tmp_* tmp_snapshot_* tmp_staging_* There are others that end with: _ii _dd _all. The first six are various forms of permanent "temporary" tables, used for temporary processing of data. The *_all tables are used to remove the requirement that another site must be […]
Jul 6th, 2014 | Filed under Application, Development