Post reply

MSSQL 2005 database on MSSQL 2008 server

  • November 7, 2010 at 2:37 pm

    #388182

    I am on a shared hosting environment, and my hoster wants to put my MSSQL 2005 database on the MSSQL 2008 server, he tells me all works ok and that they are compatible? I have many TSQL scripts etc

    Are they, are there any know issues with this database to sever match up ???

    Please advise ...thanks:-)

  • November 7, 2010 at 2:49 pm

    #1247480

    There are features that changed and things that got removed. You should test carefully on SQL 2008 before upgrading.

    Be aware once you attach a SQL 2005 DB to SQL 2008 it becomes a 2008 database and cannot be downgraded (vial backup/restore or detach/attach) again.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 7, 2010 at 2:55 pm

    #1247484

    Thanks for that advice, thats something they didnt tell me...

    Ok..

  • November 18, 2010 at 10:04 pm

    #1252856

    or you can open the SQL Server 2005 instances from the SQL server 2008 management studio. In this you will be working as if in SQL server 2005.

  • December 1, 2010 at 7:02 am

    #1257326

    or leave the compatibility to 90?

    My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access[/url]

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

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