Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Dhiren 60 posts 202 karma points
    May 07, 2015 @ 09:46
    Dhiren
    0

    Migrating from SQL Standard Edition to Enterprise Edition

    Hi,

    Our client is migrating our umbraco Database from SQL Standard Edition to Enterprise Edition.
    1) Can anybody let me know if is there any issue will occur due to this? 
    2) Will Courier work with Enterprise Edition properly?

    Thanks in advance.

    Thanks,
    Dhiren

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    May 07, 2015 @ 10:01
    Jan Skovgaard
    0

    Hi Dhiren

    What versions of the databases are being used? If you're going from 2008 to for instance 2012 there should be no issues - But if you're using 2012 standard edition and 2008 enterprise edition there might be some challenges doing the migration. Or if you're using SQL 2008 R2 - But Umbraco and Courier should work fine on any version of the MSSQL databases to my knowledge.

    But make sure to keep a backup of the data before starting the process of course.

    /Jan

    Copy Link
  • Jeavon Leopold 3074 posts 13632 karma points MVP 11x admin c-trib
    May 07, 2015 @ 10:20
    Jeavon Leopold
    0

    Hi Dhiren,

    Yes, the edition of SQL servers doesn't make any difference to Umbraco.

    Do you know why they are migrating to Enterprise? We only use Enterprise edition for AGL's, these also work with Umbraco if configured correctly.

    Jeavon

    Copy Link
  • Dhiren 60 posts 202 karma points
    May 07, 2015 @ 10:20
    Dhiren
    0

    Hi Jan,

    Thanks for your quick response.

    We are migrating from SQL Server 2012 Standard Edition to SQL Server 2012 Enterprise Edition. Will it create any specific issue?

    Thanks,
    Dhiren 

    Copy Link
  • Dhiren 60 posts 202 karma points
    May 07, 2015 @ 10:24
    Dhiren
    0

    Hi Jeaven,

    They are migrating due to AlwaysOn feature of SQL which is only availabe in Enterprise edition.

    Dhiren 

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    May 07, 2015 @ 10:37
    Jan Skovgaard
    0

    Hi Dhiren

    Ok, but then there should be no compatibility issues.

    /Jan

    Copy Link
  • Jeavon Leopold 3074 posts 13632 karma points MVP 11x admin c-trib
    May 07, 2015 @ 10:56
    Jeavon Leopold
    100

    Hi Dhiren,

    Exactly "Always On" feature means you connect to a AGL (availability group listener) instead of a SQL Server directly. We have been using the feature, the only thing you need to do is add "MultiSubnetFailover=Yes" to your connection strings.

    However correctly configuring the AGL and all the other required services for "Always On" is complex so make sure they know what they are doing with it.

    Jeavon

    Copy Link
  • Dhiren 60 posts 202 karma points
    May 07, 2015 @ 12:33
    Dhiren
    0

    Hi Jeavon,

    Thanks for your quick response. Can you please help me in understanding what exactly this "MultiSubnetFailover=Yes" does?

    Thanks,
    Dhiren 

    Copy Link
  • Jeavon Leopold 3074 posts 13632 karma points MVP 11x admin c-trib
    May 07, 2015 @ 13:02
    Jeavon Leopold
    0

    Hi Dhiren,

    I know only as much as detailed in this extensive post on the subject.

    Jeavon

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft