locked
MDS 2012 - Moving data only from Prod to Dev RRS feed

  • Question

  • I am in need of just restoring the data in our Prod MDS 2012 instance over to our Dev environment.  The models/entities are current on both sides, we just need some current data in dev for some testing.  

    Is it possible to just backup and restore the MDS database from one to the other?  I don't necessarily want to use MDSModelDeploy because all I want is the data.  


    Andy Carita

    Monday, June 30, 2014 4:34 PM

Answers

All replies

  • Andy, 

    Here is a posting that I think answers your question.

    Can I Backup MDM database and restore it on different server

    Reeves


    Denver, CO

    • Marked as answer by Andy Carita Thursday, July 17, 2014 2:36 AM
    Thursday, July 3, 2014 8:06 PM
  • Thanks,

    I had seen that and read through it, but it seemed to me that it was specific to SQL 2008.  I don't know if the same properties exist in 2012 or if I can just follow those steps without any issue.


    Andy Carita

    Monday, July 7, 2014 12:10 PM
  • Andy, 

    I do not think there would be any difference with SQL Server 2012 compared to SQL Server 2008 R2.

    Reeves


    Denver, CO

    Saturday, July 12, 2014 3:32 AM