SQL 2005 database to open SQL 2008 database

Question

hi

Need help. I have this question.

I have this database created in SQL Server 2008. But my developers only have SQL 2005. They are able to open this database in SQL 2005 using SP4(not with any other SP's). Is this method is correct and can they write all INSERT/DELETE/UPDATE/SELCT & create SP. Will it make an issue to SQL Server 2008 database as it is created in SQL 2008.

And if it is correct, is it mentioned in any of the MS documents. Thanks.

Regards

Sajith

Answer 1

Sajith ,

Did you mean your developers use ssms2005 to connect to sql 2008? if so it is fine, but they might not be able to use the new functionalities which are only supported in SQL 2008 SSMS (if any)

You wont be able to restore a sql 2008 database to a sql 2005 instance.

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 2

It really doesn't matter if you are using a different version of Management studio to access a SQL Server version. Only few options in the management studio may not be available. However the other operations should be working all fine

---

Satheesh
My Blog | How to ask questions in technical forum

Answer 3

hi

Need help. I have this question.

I have this database created in SQL Server 2008. But my developers only have SQL 2005. They are able to open this database in SQL 2005 using SP4(not with any other SP's). Is this method is correct and can they write all INSERT/DELETE/UPDATE/SELCT & create SP. Will it make an issue to SQL Server 2008 database as it is created in SQL 2008.

And if it is correct, is it mentioned in any of the MS documents. Thanks.

Regards

Sajith

Answer 4

Thanks  Praveen. In order to support this, is there is any documents provided by microsoft.

The reason for asking is, the Release version of SQL 2005 will not support this. Only SP4 support this. So I am curious, does MS really support this ?

Answer 5

Thanks  Praveen. In order to support this, is there is any documents provided by microsoft.

The reason for asking is, the Release version of SQL 2005 will not support this. Only SP4 support this. So I am curious, does MS really support this ?

Please dont post duplicate question.

MS product life cycle can be seen from below link

http://support2.microsoft.com/lifecycle/search/?sort=PN&alpha=sql&wa=wsignin1.0

Regarding SQL Server 2005 Support see below

http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/01/27/end-of-mainstream-support-for-sql-server-2005-and-end-of-service-pack-support-for-sql-server-2008-sp1.aspx?

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP