Setting up an Additional Organisation using Dynamics CRM On-premise

SQL Server Management Studio

Article sections

    Summary: Steps on how to import an additional organisation in to Microsoft Dynamics CRM. UAT, testing and development are examples of why you may want an additional organisation.
    Article Type: Information / Troubleshooting / Support
    Related Product(s): This article relates to the following products:

    • Microsoft Dynamics CRM 2015
    • Microsoft Dynamics CRM 2013
    • Microsoft Dynamics CRM 2011
    Related Articles:


    Setting up an additional organisation using Dynamics CRM On-premise

    CRM Organisation List

    CRM Organisation List

    A request which often comes my way is to set up additional CRM organisations. These are usually for testing and development reasons, or perhaps for a UAT type.  This means, in most cases, a copy of an existing organisation is needed. Here are the steps on how to set up an additional CRM organisation using an existing organisation as a template.

    High-Level Steps

    The process to create additional organisations can be repeated over and over again. This doesn’t mean you can create lots of organisations on a single server as this will eat up resources.
    Creating an additional organisation can be broken down in the following parts:

    • Obtain a SQL backup of the original organisation database
    • Restore this database with an appropriate name
    • Import the organisation into CRM
    • Add users and security roles

    It’s quite possible, a copy of another organisation is not needed. If this is the case, you can jump straight to the Deployment Manager on the CRM server and add a new organisation.

    Importing a database into Dynamics CRM

    SQL Server Management Studio

    SQL Server Management Studio

    You will need to restore the SQL backup using SQL Server Management Studio. Steps to do this are out of the scope of this article but there isn’t anything unusual to note. One thing to consider is naming conventions. There is no hard and fast rule on how to name your CRM database however it should make sense, meet business standards, and should be prefixed with “_MSCRM”. My blog What’s in a title? – Naming Microsoft Dynamics CRM On-Premise has some tips on naming conventions.

    Once the database is restored, its time to import the database in to CRM.

    Steps to Import a CRM Organisation

    Import Dynamics CRM Organisation

    Import Dynamics CRM Organisation

    Here are steps on how to import a CRM Organisation using an existing database:

    1. Log on to your CRM Server and open Deployment Manager
    2. Select Import Organisation
    3. Select the SQL Instance and database
    4. Type in your display name and unique name. Again, check out my blog on naming conventions
    5. Enter the URL for your report server
    6. Map the users from the database. Automatically Map Users should be enough if the database is from the same domain
    7. Resolve any issues and click next to import the database

    Finish the process by logging in to the new organisation and add the required users and security roles.

    Related Information:

    in MicrosoftMicrosoft Dynamics CRMMicrosoft SQL ServerSupport
    Share This Post
    Share on facebook
    Share on linkedin
    Share on twitter
    Share on email
    More To Explore

    Ready to Talk about your Project?
    Book a free Discovery Call

    A no obligation call to discuss your business needs and project requirements. During the call, our consultant will explain how we can help you to achieve your goals and answer any questions you may have.