Convert SQL 2005 Databsase back to SQL 2000 database??
Posted on 2007-12-04
Long story short, we have an SQL 2000 database that we converted to an SQL 2005 database for use with an unreliable yet extremely necessary third party software. after the convert and install, software developer now says SQL 2005 is not compatible. IF IF IF they are correct (and that is a BIG BIG BIG IF, they have not yet provided any reliable information) is there a way to roll back the converted SQL 2005 database to a 2000 SQL database. Don't know if it matters but the thrid party software uses an MS Access front end.
Again, is there a way to convert an SQL 2005 database back to an SQL 2000 database?