You’re offline. This is a read only version of the page.
826
Hi Everyone,
im trying to set up a new Test environment for CRM 2016 on-premises,
i need to copy the users , customization , reports and everything in Production database (Prod_CRM) to Test .
is it a good approach to backup Prod_CRM database from Production sql server and restore the same in Test database in Test Server and use deployment manager to import ?
should i have to do the same for MSCRM_Config database (Since it contains some setting for dynamics CRM) ?
*This post is locked for comments
Hi Ram,
Your understanding is correct , few clarification -
If you are using same server creating new organization then you don't need to worry about config database you can use same config database. You just need to restore MSCRM DB in different name and pointing to the MSCRM DB import the organization. You also don't need to worry about all users ,customization , reports everything will be move new organization.
If you have completely different environment for Application or DB server , then you need to have another CRM instance where you need to restore both the database.And using Deployment manager imort the Organization DB. You might be face some challenges to map all the users if you are not using same AD. Also you need to point the separate report server at the time of organization import and off course everything will be moved in new test instance.
Hi Ram,
That would be the correct approach.
You don't need to backup/restore the Config database. That will already exist in your Test environment and any information from the database that you import will be configured there.
Backup your production DB, Restore in SQL on Test and use deployment manager. Although not required, I would restore the database using a different name. For example if you production is CRM_MSCRM, restore it as CRMTest_MSCRM. Also with deployment manager use CRMTest as the name of the database (display name does not matter).
This is also important if you are using IFD to keep names different between the instances.
Hope this helps.
Hi Ram,
Yes, your understanding is correct. You need to take a back of prod and then use import organization in deployment manager. MSCRM_Config is the deployment database common for your entire crm deployment. You don't need to do anything on this.
You can refer the below article, its old but still holds true-
www.crmcodex.com/.../how-to-backup-and-redeploy-an-organisations-database
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (