Convert SQL Server 2008 database to SQL Server 2005?

You can script your 2008 database to create the database objects and insert data, then run that script on the 2005 instance. You might have to temporarily disable foreign keys to get some of the inserts to work.

If you want to set the compatibility level of your 2008 SQL Servers to be 2005 (so that you are effectively saying that they are all 2005), you can use the SET COMPATIBILITY_LEVEL command to do this...MSDN link Using there example, you would run this on your 2008 databases: ALTER DATABASE database_name -- change me! SET COMPATIBILITY_LEVEL = 90 -- set to sql server 2005 compatibility level.

I really need to convert my database to sqlserver 2005. – LightWing May 10 at 5:58 @LightWing, as far as I understand (and it's not a lot) as long as you are NOT using "2008" features, you can just script your 2008 database into 2005...or use a SQL Schema comparison (like redgate sql compare) to move the schema from 2008 to 2005...again, unless you are using 2008 features, everything you've got is backwards compatible already... – davidsleeps May 10 at 6:03 +1: Beat me to it – OMG Ponies May 10 at 6:42.

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.