Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MSSQL 2005 database on MSSQL 2008 server Expand / Collapse
Author
Message
Posted Sunday, November 7, 2010 2:37 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, June 8, 2014 9:18 PM
Points: 420, Visits: 559
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
Post #1016966
Posted Sunday, November 7, 2010 2:49 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 42,462, Visits: 35,525
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 2008, MVP
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

Post #1016969
Posted Sunday, November 7, 2010 2:55 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, June 8, 2014 9:18 PM
Points: 420, Visits: 559
Thanks for that advice, thats something they didnt tell me...

Ok..
Post #1016973
Posted Thursday, November 18, 2010 10:04 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 5, 2011 6:02 AM
Points: 2,242, Visits: 208
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.
Post #1023296
Posted Wednesday, December 1, 2010 7:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 11, 2014 4:21 AM
Points: 97, Visits: 392
or leave the compatibility to 90?

My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access
Post #1028615
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse