 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / January 2006SQL 2000 + SQL 2005 Express Compatibility
Hi everyone Sofar I have used SQL 2000 developer edition. So I was pretty happy that MS jumped on the freeware train and gave us SQL 2005 Express Server. In my opinion it has just just the same key feature as the SQL 2000 developer edition: for developers (simple applications) to use on one single machine. So I was pretty convinced that it would be easy to restore a new SQL 2005 Express DB with an existing SQL 2000 DB file. Unfortunately I was not able to do this. So you can imagine I was pretty disapointed. This would mean, that I still have to work with the SQL 2000 developer edition. (Is that the meaning of freeware) So my Question is, did I overlook something, and the Restoring is still afterall possible, or is it really impossible to restore a SQL 2005 Express DB with an existing SQL 2000 DB file, which in my opionion would be a big MS fault. Backward compatibility? Thanks for the Help Marcel I had same problem moving from 2000 to 2005 EE. I dont remember all details, but I couldnt simply attach db files to 2005EE before explicitely detaching it from 2000 (with sp_detach command). > Hi everyone > [quoted text clipped - 19 lines] > Thanks for the Help > Marcel Hi Thanks for the answer. Could you please explaine " before explicitely detaching it from 2000". What do i have to do, to maker it work. Thanks Marcel >I had same problem moving from 2000 to 2005 EE. > I dont remember all details, but I couldnt simply attach db files [quoted text clipped - 24 lines] >> Thanks for the Help >> Marcel I mean - execute sp_detach_db at SQL Server 2000, copy files to 2005 EE and try to attach it to 2005 EE > Hi > [quoted text clipped - 33 lines] >>> Thanks for the Help >>> Marcel hey, microsoft is coming out with a patch for SQL 2005 operability via Access Data Projects; but it is 2003 only. And i've heard it will come with a crosstab query wizard THANK GOODNESS MICROSOFT IS FINALLY TAKING US SERIOUSLY!! sp_detachdb? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.