Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Andrew Bright 84 posts 244 karma points
    Jun 14, 2019 @ 11:43
    Andrew Bright
    0

    Database migration

    Hi guys hopefully an easy question but I have a website currently running Umbraco v7.5.8 and SQL Server 2012. My hosting company has advised I need to migrate from SQL Server 2012 to 2017 will this cause any issues with CMS or are there any pitfalls please?

    Thanks

    Andrew

    Copy Link
  • Magnus Eriksson 122 posts 362 karma points
    Jun 14, 2019 @ 12:20
    Magnus Eriksson
    0

    Shouldn't be any compability problems, just make sure there are no updates to the DB between the backup is taken and the connection string is updated to the new sql server (or however they do the migration).

    Regards, Magnus

    Copy Link
  • Brandon Osborne 38 posts 161 karma points c-trib
    Jun 14, 2019 @ 12:22
    Brandon Osborne
    0

    Heya Andrew,

    You really shouldn't have any problems with simply migrating the DB from MSSQL 2012 => 2017. I've done this several times in the past.

    Copy Link
  • Andrew Bright 84 posts 244 karma points
    Jun 20, 2019 @ 11:35
    Andrew Bright
    0

    So I managed to create an MSSQL 2017 and restore from 2012 however when updating the connection string in the web.config umbraco loads the site and prompts me to login to authorize an upgrade?? however, my login details dont work..

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft