Discussion in 'SQL Server 2008 General DBA Questions' started by dba_boston, Feb 20, 2009.
Does anyone has the experience of downgrading the sql 2008 to either 2005 or 2000?
There is no direct option like backup restore from new version to older version because sql server bakups are not backward compatible...
You can script and create the objects and copy the data...
You can use the option for data scripting in sql 2008, please check the following blog...
Additionally, you can also use copy database option. Remember to use the SQL management object method in transfer method.
Try to use this method.http://chamilaw.blogspot.com/2011/04/how-to-restore-sql-server-2008-to-sql.html
Welcome to the forums!Chamila this thread is 2 years old.
Separate names with a comma.