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.

RESTORE SQL Server to msde?

Is it possible?
How about all dev in sql server then migrate to "production msde" using either DTS or bcp and DDL scripts?
Can you bcp in to msde? And is msde true client server?This is a start!


http://groups.google.com/groups?q=msde+database+restore&hl=en&lr=&ie=UTF-8&group=microsoft.public.sqlserver.*&selm=2l7qo3F9s4e1U1%40uni-berlin.de&rnum=3|||MSDE is the desktop version of SQL Server. It is limited in terms of only 2 Gb per database, and only 5 simultaneous active spids per instance, but those are the only significant limitations.

I don't remember if BCP is included in the executables, although OSQL.EXE definitely is. The Transact-SQL BULK INSERT command works just fine, and is simply a different interface to the same API that BCP uses.

DTS works on an MSDE instance without any reservations that I know of, other than the limitations imposed by MSDE itself.

-PatP|||Cool...so if they want this application to be distributable...should be no problem...right?|||No problem I can see. Don't overlook the easy answer if you can just detach the database and zip it though!

-PatP