Migration from SQL Enterprise to SQL Standard

  • We are planing to migrate the data from the SQL Enterprise edition to SQL standard Edition

    1) what exactly we have to look for before migration?

    1) what exactly we have to look for during migration?

    3) what exactly we have to look for after migration?

    4) is there any issue arise during the migration occurs?

    thank you guys in advanced

    Nirav

  • I would start with the features that SQL Server Standard does not support that Enterprise does. Those would be the most obvious. (Like partitioning tables, etc)

  • Unfortunately, you cannot simply detach the database from Ent and re-attach it in Standard. A backward conversion is not provided and there is a flag in the DB that indicates which edition it was created/used on.

    You will need to use the import/export wizard under the database tasks menu. This should help with anyting like partitioned tables.

    However, if you used any commands or features in stored procedures and functions, you will need to go through them one-by-one and eliminate the references and statements before the stored procedures and functions can be migrated. Same with views if you indexed them.

  • jerry-621596 (6/10/2011)


    Unfortunately, you cannot simply detach the database from Ent and re-attach it in Standard. A backward conversion is not provided and there is a flag in the DB that indicates which edition it was created/used on.

    Are you sure about that?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I have a similar situation, I have a currently SQL 2008R2 db running on ent, (no using any of the ent features) and I want to move that db to a SQL 2008 R2 Std - what is the way to do this >? - Can a simple backup and restore achieve this ?

  • Hi

    olaf.dedig And niravbhat

    You both should Install and check on stand by box and be sure youe application is working fine.

    That solved

    Ali
    MCTS SQL Server2k8

  • Here:

    http://beyondrelational.com/blogs/brumedishetty/archive/2010/04/29/downgrading-sql-server-enterprise-edition-to-standard-edition.aspx

    you can find details about "Downgrading SQL Server Enterprise Edition to Standard Edition"

    Good luck 🙂

  • A nice place to start would be sys.dm_db_persisted_sku_features[/url].



    Ole Kristian VelstadbrĂĄten BangĂĄs - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

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