Moving live CRM 4 db to Development server

Taylor Made Development Solutions Blog Post

When doing CRM development its sometimes important to take a copy of the LIVE CRM database and deploy it on your CRM Development server.

The steps below cover this scenario, presuming you already have CRM on your Development server:

  1. Use SQL Management Studio to restore the database to your development server; make usre you restore it to a different name than the one already deployed to DEV (as part of the install)
  2. Remove the Users and corresponding schemas from the restored database
  3. Run the CRM Deployment Manager to do an import; then follow the rest of the steps in Microsofts guid here:

http://support.microsoft.com/kb/952934

The undocumented step 2 above cost me a few hours teh first time I went through this process; see this article:

(http://serverfault.com/questions/277540/dynamic-crm-2011-import-organization-from-different-locale-fails-on-sqlexception )

Posted by on February 22nd, 2012 at 16:55
Categories: CRM, Development

Related Posts

  1. Blogging using Microsoft Live Writer

About the Author

Written by Matt Takhar

Matt has a background in engineering and has 15+ years of IT experience. He has been working with SharePoint since 2006. In 2007 he attended a 6 day SharePoint boot camp by Firebrand training, and joined the Taylor Made team. He passed the WSS 3.0 and MOSS 2007 exams and which makes him a Microsoft Technical Specialist in SharePoint. Since 2007 he has been specialising in delivering SharePoint solutions and in 2009 he changed roles to Software Development Manager, where his team specialises in developing SharePoint and Project Server based solutions amoungts many other technologies.

Comments

No comments.

Leave a comment

Your email is never published nor shared. Required fields are marked *

*

You may use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>