June 10, 2011 at 8:43 am
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
June 10, 2011 at 12:43 pm
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)
June 10, 2011 at 4:28 pm
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.
June 10, 2011 at 5:20 pm
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
October 10, 2011 at 5:27 am
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 ?
October 10, 2011 at 5:51 am
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
October 11, 2011 at 9:12 pm
Here:
you can find details about "Downgrading SQL Server Enterprise Edition to Standard Edition"
Good luck 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply