Sql database 2008 to 2005

Other SQL Server Topics
1

Hi,
My database is running on sql server 2008 but my other server running on sql server 2005 how do i migrate my database from 2008 into 2005 thx

2

right-click on the database, choose Tasks and Generate Scripts

Script out all objects targeting 2005, procs, views, functions, tables (schema and data), indexes etc. to a files

then in 2005, run the script produced

3

thanks....alot