Category Archives: SQL Identity

Information on Database Configurations in Sage CRM

Upon installing Sage CRM apart from selecting the installation path we are required to provide instance name and SQL server connection details to proceed further with installation. Whatever the instance name that we provide upon installation, the installation process will create a database in SQL with same name and required tables in the database. The… Read More: Information on Database Configurations in Sage CRM »

SageCRM Record Id generation old and new methods

How you design your database has huge effect on how your system performs. Primary key, foreign key constraints help to keep the tables linked to each other and store the data in unified manner. From long time SageCRM has followed strategy of generating primary keys through stored procedures rather than relying on the inbuilt primary… Read More: SageCRM Record Id generation old and new methods »