none
Move FIM Sync Service and FIM Service SQL 2008 DBs to another server running SQL 2012

    Question

  • We have just upgraded to FIM 2010 R2 SP1 and are now looking at updating our SQL database from 2008 to 2012.  I understand FIM 2010 R2 can be run on SQL 2012 and that it is possible to move FIM databases from one server to another if the version of SQL is the same between the two servers.  But what about moving a FIM SQL 2008 DB to SQL 2012 on a different server?  Has anyone tried this and if so what steps did you take to get it to work?

    My first thought would be to upgrade the FIM DB to SQL 2012 on the server that it currently lives on and then move the DBs to a new SQL DB server.  Then use steps similar to what is outlined here (http://social.technet.microsoft.com/wiki/contents/articles/5465.reference-how-to-move-the-backend-sql-server-synchronization-service-database.aspx) to point FIM Sync Service to the new DB location.  I haven't tried this though and would appreciate a second option.

    Thanks

    Wednesday, May 01, 2013 11:25 PM

Answers

All replies

  • According to the release notes:

    • Upgrade FIM Sync to FIM 2010 R2 SP1
    • Stop FIM Sync
    • Backup Database [in case rollback needed]
    • Upgrade SQL to SQL Server 2012
    • Start FIM Sync

    The registry key in your linked article would be changed before that last step.

    Chris

    Thursday, May 02, 2013 9:59 PM
  • Hi Chris,

    Thanks for the reply.  I think the instructions you are referring assumes the DB is not being moved to a new server.  I need to move the database to a new server as part of the upgrade, which means telling FIM where the new DB lives.  I'll going to try the steps outlined in the technet article I listed above and see how that goes.

    Friday, May 03, 2013 4:02 PM