Solved

Convert SQL 2005 Databsase back to SQL 2000 database??

Posted on 2007-12-04
5
2,133 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
  • 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 125 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now