Usage notes (Microsoft SQL Server)
Usage notes (Microsoft SQL Server)
If you use Archibus with the Microsoft SQL Server database, be aware of the following usage notes.
- Database Update Wizard. If you are performing large updates and you are using a Microsoft SQL Server database as your source database, run the Database Update Wizard in phases. First copy the data dictionary, then restart the Wizard. Then generate tables, and restart the Wizard. Then copy data, and restart the Wizard. There are resource consumption issues with the Microsoft SQL Server driver that cause failures in the Database Update Wizard if run continuously.
- Delete Table Command. If you delete a table that has child records, you will get an SQL error since the records are deleted in bulk, and the bulk change does not cascade.
- Replace Column Command. You should use the Replace Column command only in views that do not contain a table in the standard role.