Developing SQL 2005 application using SQL 2008 server?

Just install SQL Server 2005 express and use that At some point, developing an backward compatible app will come back to bite you because there are differences in data types deprecated features, discontinued features, and behaviour changes The list is too long to try and remember for development.

Just install SQL Server 2005 express and use that At some point, developing an backward compatible app will come back to bite you because there are differences in data types, deprecated features, discontinued features, and behaviour changes. The list is too long to try and remember for development.

1. Why do people fight for not just doing the most sensible thing. Install a 2005 instance.

– TomTom Oct 18 at 8:20 This is the obvious solution, but my question is if there is any better way to do this? – user654019 Oct 19 at 8:48 1 @user654019: No. Never develop for an older version.It'd be acceptable, mostly, to work on SS2005 for SS2008 but never the other way around – gbn Oct 19 at 9:08.

Short answer: yes. But there are some differences between SQL 2005 and SQL 2008 databases. You should read up on those to make sure your database is compatible with SQL Server 2005.

For example some datatypes only exists in the one version and not the other and so on.

Thank you. Can you please elaborate more? What should I do in EF and in database creation?

Where can I find information about the datatypes which is not supported in 2005 and so on? – user654019 Oct 18 at 7:56 It's too much information to gather without knowing the specifics of your application. As gbn mentioned you are better off installing a sql 2005 express instead of spending valuable time googling around for differences between sql 2005 and 2008 – Jonas B Oct 18 at 15:11.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.