InstantForum.NET v4.1.4Interprise Suite Communityhttp://www.interprisesuitecommunity.com/forums@dimesoftinc.comFri, 10 Feb 2012 18:13:44 GMT20http://www.interprisesuitecommunity.com/Topic218-4-1.aspxI'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.<br><br>I have not been able to move the database successfully from 2005 to 2000. I tried:<br>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...<br><br>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.<br><br>Anyone know how to accomplish this? <br><br>Thanks.<br><br>Thu, 23 Jul 2009 08:17:16 GMTJim Wolf