Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2158
  • Last Modified:

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?


0
shmedlick
Asked:
shmedlick
  • 3
  • 2
1 Solution
 
Chris MangusDatabase AdministratorCommented:
Put the database back into 8.0 compatibility mode, after doing a backup, of course.

It will function exactly like a database on a 2000 server would.  I run many of them this way with no issues.
0
 
shmedlickAuthor Commented:
i put it back into 8.0 compatibility mode, install SQL 2000 server and it'll run as if nothing ever happened?
0
 
Chris MangusDatabase AdministratorCommented:
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.
0
 
shmedlickAuthor Commented:
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?
0
 
Chris MangusDatabase AdministratorCommented:
No, the database won't convert downward to something you can simply attach to SQL 2000.

Your best bet at this point is to try and use the copy database wizard to put it all back on a 2000 instance.

It amazes me that vendors won't work with SQL 2005 servers in 8.0 compatibility mode.  I feel your pain.  I have 130+ SQL Servers and have a couple vendors who do this too.  Even though we've demonstrated to them that everything works, they want to blame their coding problems on SQL Server.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now