Export SQL Server 2005 Express to SQL Server 2000

I'm trying to export a SQL Server 2005 Express database to SQL Server 2000 sp4, but have so far been unsuccessful. SQL 2005 Express doesn't have an Export Data function and backup/restore doesn't work because of the different versions.

Any suggestions greatly appreciated!

I dont think you can move dbs from higher version to lower.....you cannot perform backup/restore nor detach/attach.......the same applies to sql 2005 to sql 2000

|||

Well, Deepak is right, you will have to use the Import functionality of SQL Server 200 to get the data from the 2k5 to the 2k database.

Jens K. Suessmeyer

http://www.sqlserver2005.de