{"id":1509,"date":"2015-05-18T13:59:05","date_gmt":"2015-05-18T13:59:05","guid":{"rendered":"https:\/\/mahenderpal.wordpress.com\/?p=1509"},"modified":"2015-05-18T13:59:05","modified_gmt":"2015-05-18T13:59:05","slug":"deleting-microsoft-dynamics-crm-2013-organization-from-sql","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=1509","title":{"rendered":"Deleting Microsoft Dynamics CRM 2013 Organization from SQL"},"content":{"rendered":"

Requirement<\/strong>: Delete Microsoft Dynamics CRM Organization<\/p>\n

Solution<\/strong>: We can follow below steps to delete Dynamics CRM Organization from DB.<\/p>\n

    \n
  1. Connect to CRM DB server and right click on CRM organization DB (for example DEMO_MSCRM<\/strong>)<\/li>\n
  2. Select Delete and make sure to select Close existing connections<\/li>\n<\/ol>\n

    \"MDMD\"<\/a><\/p>\n

    This will delete organization DB , but we also need to remove Organization references from MSCRM_CONFIG DB, so follow below steps.<\/p>\n

      \n
    1. Fire below select statement against MSCRM_CONFIG DB<\/li>\n<\/ol>\n

      select * from [dbo].Organization<\/strong><\/p>\n

        \n
      1. Note down ID of your organization, we need it for below queries.<\/li>\n
      2. Execute following commends against MSCRM_CONFIG DB, you can change parameter and run all of them in one go<\/li>\n<\/ol>\n

        \u00a0 \u00a0 \u00a0 \u00a0 \u00a0delete from [dbo].[OrganizationFeatureMap] where OrganizationId=\u2019ORG_GUID\u2019<\/strong><\/p>\n

        \u00a0 \u00a0 \u00a0 \u00a0 \u00a0delete from [dbo].SystemUserOrganizations where OrganizationId=\u2019ORG_GUID\u2019<\/strong><\/p>\n

        \u00a0 \u00a0 \u00a0 \u00a0 \u00a0delete from [dbo].[OrganizationProperties] where Id=\u2019ORG_GUID\u2019<\/strong><\/p>\n

        \u00a0 \u00a0 \u00a0 \u00a0 \u00a0delete from dbo.Organization where DatabaseName=\u2019ORGNAME_MSCRM\u2019<\/strong><\/p>\n

        Note: This is an unsupported method of removing Organization DB and should be used only when not able to delete organization from Deployment Manager for specific reasons.<\/strong><\/p>\n

        Hope it will help someone !!<\/p>\n","protected":false},"excerpt":{"rendered":"

        Requirement: Delete Microsoft Dynamics CRM Organization Solution: We can follow below steps to delete Dynamics CRM Organization from DB. Connect to CRM DB server and right click on CRM organization DB (for example DEMO_MSCRM) Select Delete and make sure to select Close existing connections This will delete organization DB , but we also need to remove Organization references from MSCRM_CONFIG… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[65,140],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1509"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1509"}],"version-history":[{"count":0,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1509\/revisions"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}