Restored database from sql server 2005 to 2000

Is there any workaround on this? I need to migrate my data in sql server 2005 into sql server 2000. Thanks in advance.

I would use theSQL Hosting toolkit to move the database to an older version of sql server. Create a script to recreate the database. Then execute the script on the older version of sql server

|||

Hi,

You can only restore database from SQL Server 2000 to SQL Server 2005,

but you can not restore a database from SQL Server 2005 to SQL Server 2000.

Think about it for minute, there are new features and data types that exist only in SQL Server 2005, so it can not work in SQL Server 2000.

However, you may export your data to MS Excel from SQL Server 2005 and then import data from excel to SQL Server 2000.

This may be a workaround for you.