web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Organization ID is mai...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Organization ID is maintained when importing from another deployment

(0) ShareShare
ReportReport
Posted on by WillD44 172

If you import an organization from one deployment to another using a SQL backup, the organization keeps it's organization ID.  If you import a second organization from a later backup, it still keeps the ID.  I suppose that might be by design as it's just a later backup of the same SQL database.  How do we import a later backup as a new organization?  

This all becomes relevant when performing an upgrade.  The deployment manager seems to get lost when performing an organization upgrade if it's working on a duplicate organization ID.

I have the same question (0)
  • Suggested answer
    Pedro Cadavez de Freitas Profile Picture
    Pedro Cadavez de Fr... on at

    Hello WillD44 ,

    Hope you are well.

    There is an internal procedure when you import a CLONE org into the same deployment that checks if there is already an ORG with the same orgID on that deployment. If yes, the procedure will generate a new orgID and update all required tables columns that use ORGID with the new orgID.

    So, we don't expect you have 2 ORGs on the same deployment with the same orgID, as that would cause a whole lot of problems.

    Are you sure they have the same ORGID? where are you checking that?

  • WillD44 Profile Picture
    WillD44 172 on at

    The MSCRM_CONFIG.Organization table and also the <mydatabase>.OrganizationBase table is where I'm seeing the IDs.  This seems to be where the organization upgrade gets lost according to the log files.

  • Pedro Cadavez de Freitas Profile Picture
    Pedro Cadavez de Fr... on at

    What CRM version are you using?

    Share the full build number from Deployment manager, servers section.

    This shouldn't occur.

    importing a clone DB into a deployment manager that has already the same orgID should trigger a new orgID.

    In any case, cloning DB's should be avoided due to inconsistencies like this.

    What you your business case that you need to import clones?

    What about working on them on different deployments?

  • WillD44 Profile Picture
    WillD44 172 on at

    Build # : 9.1.0016.0020

    We are migrating CRM to new server and also upgrading versions from 8.2 to 9.1.

    We restore a backup of the 8.2 organization into the new 9.1 server in order to do user testing.  This data becomes stale after short period.  So we do another restore of new backup into the 9.1 server.  This is when the problem occurs.

    Once all testing & training is complete, we will do a final restore from the 8.2 server to the 9.1 server and this will become our new production environment.  The 8.2 server will be decommissioned then.

  • WillD44 Profile Picture
    WillD44 172 on at
    Sounds like that internal procedure isn't working.  Is there a way to execute it manually?
  • WillD44 Profile Picture
    WillD44 172 on at
    This OrgID issue is also part of the server-side sync with Exchange.  Apparently when you Test & Enable the users mailbox, it writes the OrgID to Exchange.  So in the case of the organization on our new CRM server, the OrgID is the same as the one we imported from.  That sounds like it will cause problems when we cut over to the new CRM server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans