none
Database upgradation from SQL 2008 R2 to 2014 RRS feed

  • Question

  • Hello Friends,

    We are upgrading our databases FIM databases from 2008 to SQL 2014 and to new servers as well.

    We have FIM 2010 R2(v4.1.3436) in our environment. So I just want to know how to proceed so that new servers will be adopted by our existing FIM environment.

    Can we go with in-place upgrade by just stopping the service ,so that we can provide the new db details while installing the product and registries will be configured accordingly.

    Kindly suggest.

    Regards,

    Suman

    Thursday, July 19, 2018 10:21 AM

All replies

  • Suman-

    After you swing the databases over you can rerun the FIM Service and FIM Sync setup wizards to get everything updated. You can also do this manually via the registry but if you're not familiar with the steps you're better off sticking with the setup wizard.


    Thanks,
    Brian

    Consulting | Blog | AD Book

    Thursday, July 19, 2018 3:47 PM
    Moderator
  • Thanks Brian,

    As we have Sharepoint db on the same db server where FIM DB resides. Do i need to uninstall and install the sharepoint as well?

    Regards,

    Suman

    Friday, July 20, 2018 6:55 AM
  • It varies by version but this should be a good starting point - https://docs.microsoft.com/en-us/sharepoint/administration/move-all-databases

    Thanks,
    Brian

    Consulting | Blog | AD Book

    Friday, July 20, 2018 2:19 PM
    Moderator