SQLTeam.com | Weblogs | Forums

Sql database 2008 to 2005


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


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