Some suggested routine after a Syteline Upgrade
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 and _tmp tables. These would force system to rebuild those temp tables. Please refer to Information on the different temporary tables in a SyteLine database for a script to drop all those temp table.
Categories: Application, Development _all table, _tmp, _tt, replication, Temp Table, Trigger, Upgrade
Recent Comments