Category Archives: Database

Scheduling Backup activity through Sage CRM 2014 R2

For every Business environment, managing/securing data and Disaster management responsibilities goes hand in hand. Backing up data has always been the only recommended solution for recovering data which also proves very profitable. The only risk which is involved is doing this task manually as someone may forget. Scheduling Backup activities is something which has been… Read More »

Get Size of all Tables in CRM Database

For any database driven application, it is very important that the database must be optimized to the best so as to deliver higher performance. As the data volume in database increases, load on the system also increases which affects the performance on the system which in turn affects the client’s business. For business application like… Read More »

CRM database auto-backup on SQL express Editions

Database backup is very essential in business environment to keep disaster recovery options open. Maintaining every day database backup is routine practise for all software friendly industries. However doing this task manually is very tedious job and involves lot of risk if someone forgets to backup.  New Stuff: Sage 100 user mapping with Sage CRM… Read More »

Table Level Scripts Logging and Performance

In SageCRM, Table level script can be used for replicating SQL trigger like functionality.  Table level scripts help us handle the data update events properly and do corresponding actions within SageCRM. The beauty of it is we can use SageCRM API and write server side JavaScript like functionality to function similar to that of triggers.… Read More »

Sage CRM Database Maintenance

Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. New Stuff: Confirm if your Sage CRM system has actually expired There are many ways to enhance the performance… Read More »

Quick look on Sage CRM tables

In this blog we will have a quick look at some of the important and essential tables of Sage CRM. GUMU : Integrate your Sage 500 ERP system with latest Sage CRM – Realtime In Sage CRM, entity data is stored into the tables with identical name. For example, 1. Company entity data is stored into the… Read More »