Post reply

Will there be any problem in migrating data from evaluation edition DB ?

  • March 22, 2015 at 10:00 pm

    #398221

    Hi All,

    What are the limitations of SQL Server evaluation edition ?

    Client is planning to buy a enterprise licence after 3-5 months.

    Can they test their application by using evaluation edition and then migrate the data to production once they purchase license ?

    Will there be any problem in migrating data from evaluation edition DB ?. Thanks !.

  • March 22, 2015 at 10:32 pm

    #1785609

    Have not tried it in 2014, but I wouldn't think so. Just back up and restore all the relevant databases, including msdb.

  • March 22, 2015 at 11:34 pm

    #1785612

    Thanks. No need of msdb. Only user dbs are ok for them.

  • March 23, 2015 at 12:47 am

    #1785616

    Joy Smith San (3/22/2015)

    Hi All,

    What are the limitations of SQL Server evaluation edition ?

    Client is planning to buy a enterprise licence after 3-5 months.

    Can they test their application by using evaluation edition and then migrate the data to production once they purchase license ?

    Will there be any problem in migrating data from evaluation edition DB ?. Thanks !.

    The evaluation edition is the same as the enterprise edition except that it's only good for 120 days. Your client will need to buy the enterprise edition before then or stuff is going to stop working on day 121.

    Other than that, I believe it's just a matter of changing the license key and everything will continue to work.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 23, 2015 at 7:53 pm

    #1785857

    Thanks Jeff.

    I thought its 180 days. Well, it will be a separate temporary server.

    So I just need to backup and restore all user DBs to the new prod server once it's ready.

    Thanks.

  • March 23, 2015 at 10:58 pm

    #1785873

    Joy Smith San (3/23/2015)

    Thanks Jeff.

    I thought its 180 days. Well, it will be a separate temporary server.

    So I just need to backup and restore all user DBs to the new prod server once it's ready.

    Thanks.

    Ah, sorry. Showing my age. Yes, it's 180 days and, yes, you should be able to do a restore when the new prod server is ready.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply