convert sql2005 to sql2008

[moein serpico]

hi guys is there any way to convert sql2005 database objects to sqlserver 2008 objects? show me how?

[dan sh]

SQL 2008 comes with a "Copy Database Wizard" you can make use of that to move your database from SQL 2005 to SQL 2008.

[Mycroft Holmes]

Restore or attach the 2005 database to your sql2008 server and change the compatibility level. Just what are you expecting to change when you move to 2008?

Never underestimate the power of human stupidity RAH