Can we Upgrade from sql server enterprise edition 2k5 to sql server enterprise edition 2012?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Can we Upgrade from sql server enterprise...

Can we Upgrade from sql server enterprise edition 2k5 to sql server enterprise edition 2012?

Rate Topic

Display Mode

Topic Options

Author

Message

sqlpanther

Posted Wednesday, December 05, 2012 12:20 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:29 AM
Points: 26, Visits: 130

hello All,
I need experts advised who have already started to work on sql serevr 2012, i came across an article in MSDN stating that "90 compatibility level and upgrade from version 90 (SQL Server 2005 Database Engine" is DEPRECATED and "Compatibility levels are only available for the last two versions." At my work we have Sql Server 2k5 and we are planning to go to sql server 2012 soon, does that mean i need to upgrade it to 2008 or 2008R2 and the 2012? how shall we do it? any idea guys...?

Thanks,

Post #1392811

Perry Whittle

Posted Wednesday, December 05, 2012 2:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 5,201, Visits: 11,152

you can upgrade from SQL Server 2005 Ent edition directly to SQL Server 2012 Ent edition, but the SQL Server 2005 instance will need to be at service pack 4.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1392844

« Prev Topic | Next Topic »

Permissions