Post reply

move from sql 2008 r2 express to sql 2008 standard

  • May 9, 2011 at 1:52 am

    #237825

    Hi all,

    I have a number of databases running on sql 2008 r2 express.

    But now the customer has purchased the sql 2008 standard version of the product (not R2).

    Can anyone please help me on how I can move the database's to the standard version that is not R2.

    Please provide full details as I am not a database administrator and haven't done any scripting or anything.

    Any help would be appreciated.

  • May 9, 2011 at 5:15 am

    #1321637

    I don't have that combination of databases, don't use express, but one mthod to move a database across editions/versions is to use snapshot replication. I figure that the database copy wizard might also work from sql 2008.

    Failing that it's a export and import objects and data. You might actually do better to hire a DBA

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 2 posts - 1 through 2 (of 2 total)

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