Transfer SQL Server 2008 Database and Data to SQL Server 2005
09-Aug-0909 Leave a comment
11/08/2009 This works !!
Also
SSMS > Select database > Right Click > Tasks > Generate Scripts > Proceed to "Choose Script Options"
> Under "General" change option for Script for Server Version to SQL Server 2005 or 2000
> Can not see this but "If you are putting the database on a new instance for the first time, make sure the "Script Database Create" option is set to "True.""
> under "Table/View Options" select Script Data to True
> Proceed through rest of options choosing your preferences.
Stephen Shakespeare 