Sage CRM

 View Only
Expand all | Collapse all

Doing an upgrade to Sage CRM 7.1, and I wrote a li

  • 1.  Doing an upgrade to Sage CRM 7.1, and I wrote a li

    Posted 12-22-2011 11:29
    Doing an upgrade to Sage CRM 7.1, and I wrote a little bit of T-SQL to disable all the triggers. Enabling triggers should be a simple search and replace ""DISABLE"" with ""ENABLE"". Hope you find it useful (and I hope that socialcast doesn't think I'm trying to hack their database): USE CRM; GO /* Disable all the triggers */ DISABLE TRIGGER trguUsersSyncMAS90 ON dbo.Users; GO DISABLE TRIGGER trguCompanySyncMAS90 ON dbo.Company; GO DISABLE TRIGGER trguPersonSyncMAS90 ON dbo.Person; GO DISABLE TRIGGER trguAddressSyncMAS90 ON dbo.Address; GO DISABLE TRIGGER trguAddressLinkSyncMAS90 ON dbo.Address_Link; GO DISABLE TRIGGER trguEmailSyncMAS90 ON dbo.Email; GO DISABLE TRIGGER trguPhoneSyncMAS90 ON dbo.Phone; GO DISABLE TRIGGER trguOpportunitySyncMAS90 ON dbo.Opportunity; GO DISABLE TRIGGER trguCaptionsSyncMAS90 ON dbo.Custom_Captions; GO SELECT * FROM sys.triggers WHERE is_disabled = 0; /* This, of course, allows me to check that all the triggers were disabled. */


  • 2.  RE: Doing an upgrade to Sage CRM 7.1, and I wrote a li

    Posted 01-06-2012 10:24
    the purpose for this is?


  • 3.  RE: Doing an upgrade to Sage CRM 7.1, and I wrote a li

    Posted 01-06-2012 10:33
    This is for when you upgrade CRM from 7.0 to 7.1. You have to disable triggers. Instead of doing them one by one, Aaron wrote a script to do this.


  • 4.  RE: Doing an upgrade to Sage CRM 7.1, and I wrote a li

    Posted 01-06-2012 13:04
    Thanks. Learn something every day.


  • 5.  RE: Doing an upgrade to Sage CRM 7.1, and I wrote a li

    Posted 03-08-2012 10:05
    Nice. Thanks for sharing Aaron.


  • 6.  RE: Doing an upgrade to Sage CRM 7.1, and I wrote a li

    Posted 03-08-2012 10:10
    Glad to be of service.