The Database is the most important part of Sage CRM. Sage CRM allows for the storage of business application data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. The database is also used to store the data that controls the screens and user experience of Sage CRM. Sage CRM is called a metadata driven application. The database holds the definitions of its screens in tables within the database. The database tables detail which columns should be included in which lists or screens. Everything depends on the database.
Below is a selection of key articles that cover aspects of working with the Sage CRM database.
- Data Protection
- Some thoughts about moving database servers
- Sage CRM and Client Access Licensing for MS SQL Server.
- Merging two Sage CRM databases
- Database Case-Sensitivity and Connecting to an External Case Sensitive Database
- Linking to 3rd Party Databases
- Building Cross Database Views for Reporting
- You may need to recreate views manually
- Bcrypt algorithm and user password security
- Some Thoughts about the Hard Deletion of Records
- Deploying Sage CRM on Microsoft Azure SQL
- Some thoughts about Multi-threading in Sage CRM
- The right to be forgotten and the anonymization of data