Moving Databases to new sql server

(0) Share

Report

Posted on by Community Member

I want to move my crm databases to a new sql server, and for the time being, leaving my crm server as the current deployment. I can' t seem to find the appropriate articles/instructions to do this. Can someone point me in the right direction?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Hosk on at

Like (0)

Report

RE: Moving Databases to new sql server

So you want to migrate the databases to another server and then get CRM to point to the new database server

First make sure you have everything backed up.

I think you will need to install the databases onto the new server and then you may need to repair the current CRM server install and select the new server. There maybe some registry values to edit.

The three links below go through the various values and tasks that need to be done, not all related but I think you need to understand what they are doing. It may end up you need to install the CRM server again, this shouldn't effect CRM because all the values are stored in the DB.

This article is good

weblogs.asp.net/.../Microsoft-Dynamics-CRM-2011-_2F00_-4.0-Configuration-in-Case-of-Machine-rename-_2F00_-CRM-Database-server-change-_2F00_-Domain-Controller-Change.aspx

restore CRM database

srmscrm.wordpress.com/.../how-restore-the-mscrm-organization-databases-on-the-new-computer-that-is-running-sql-server

this article is quite good, it's on CRM 4

support.microsoft.com/.../952934

Was this reply helpful? Yes No
Suggested answer

ZlobnyFar 5 on at

Like (0)

Report

RE: Moving Databases to new sql server

Hello!

What I have done to fix this problem:

1. Changed registry to point to new SQL Server

2. Changed all organization rows/records in MSCRM_CONFIG ->Organization table to use new server

a. Open SQL Server Managment Studio->browse down to MSCRM_CONFIG->Tables-> find dbo.Organization->Right click->Edit top 200 rows

b. Find "Connection string" column and change "data source=" value to your new SQL server instance name. (in my case was "devsql006" ->new sql server "devsql006\sql2012")

c. Find "SQLServerName" column and change data to your new SQL Server instance name ("devsql006"->"devsql006\sql2012")

then it worked perfectly, I hope it will help someone.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Moving Databases to new sql server

Thank you for providing the steps on how you resolved.

Harihar

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Moving Databases to new sql server

This would be highly unsupported and not worth risking a damaged CRM environment. Ben's advice as the verified answer is by far the better approach.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Moving Databases to new sql server

To move your data from CRM to a new SQL Server, I can recommend you Skyvia. It is a cloud-based solution, with broad mapping and wide scheduling features. With help of it, you can configure the operation in convenient GUI wizards with no coding and let Skyvia do the rest. Also, you can automate updating your new SQL Server with fresh data from Dynamics with no additional effort or involvement!

Was this reply helpful? Yes No