 Posted 7/23/2009 8:17:16 AM
|
|
|
|
I've got a production I/S database running in SQL 2005. I'm trying to set up a copy of the system for some development work by the web programmers. The target server is actually a production machine for some purposes, so I don't want to put a MSDN copy of SQL 2005 on there. The server has already SQL 2000.
I have not been able to move the database successfully from 2005 to 2000. I tried:
1) In 2005, changed the properties of the database to Compatibility Level SQL 2000 (80), backup, then restored in 2000. No go, error on-disk structure version 611 The server supports version 539...
2) Set up an ODBC connection on the 2000 server, pointing to the 2005 database, and then importing using that ODBC. That almost worked but eventually complained about a bad parameter to the Substring function but didn't say what SP or view that happened in. Didn't actually import anything at all.
Anyone know how to accomplish this?
Thanks.
Jim Wolf
Quality Software
Louisa, VA
|
|
|
|
