shmedlick
asked on
Convert SQL 2005 Databsase back to SQL 2000 database??
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?
Again, is there a way to convert an SQL 2005 database back to an SQL 2000 database?
ASKER
i put it back into 8.0 compatibility mode, install SQL 2000 server and it'll run as if nothing ever happened?
No, just put it in 8.0 compatibility mode. There is no need to reinstall SQL 2000.
Even in a SQL 2005 instance, a database in 8.0 compatibility mode will work just as if it's on a 2000 server.
Even in a SQL 2005 instance, a database in 8.0 compatibility mode will work just as if it's on a 2000 server.
ASKER
NO. Third party won't support it unless its on 2000 SQL. so if it doesnt work i'll have to uninstall 2005 and reinstall 2000. will the database open and run properly if it's installed on a 2000 SQL if its been put in 8.0 compatibility mode?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It will function exactly like a database on a 2000 server would. I run many of them this way with no issues.