?
Solved

Convert SQL 2005 Databsase back to SQL 2000 database??

Posted on 2007-12-04
5
Medium Priority
?
2,149 Views
Last Modified: 2012-05-05
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
Comment
Question by:shmedlick
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20403742
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
 

Author Comment

by:shmedlick
ID: 20403861
i put it back into 8.0 compatibility mode, install SQL 2000 server and it'll run as if nothing ever happened?
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20403960
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
 

Author Comment

by:shmedlick
ID: 20404156
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
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 375 total points
ID: 20404518
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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question