November 3, 2008 at 7:44 am
Guys,
I need to move my MSDE to SQL 2000 EE, what do I need to do, to perform this?
OS: WIndows Server 2003.
Thnak you for your help.
November 3, 2008 at 11:59 am
Hi,
Do you mean just moving the database or "upgrading" MSDE?
If you just want to move the databases you can do backup/restore but I don't believe you can Edition Upgrade. Looking at "Version and Edition Upgrade" http://msdn.microsoft.com/en-us/library/ms143393.aspx it is not listed and if you check the upgrade path for SQL 2005, the equivalent cannot be done.
HTH!
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 3, 2008 at 12:09 pm
Hang on, you mean from 7.0 to 2000? I forgot it is called Personal Edition in 2000. So then the link is http://msdn.microsoft.com/en-us/library/aa176562(SQL.80).aspx and no, you cannot do it.
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 3, 2008 at 12:53 pm
Hello Elisabeth,
Thank you....Yes, I need to upgrade my db from MSDE to SQL 2000, is there any way to perform this?
I have MSDE under version 8.00.760 SP3.
Thank you.
November 3, 2008 at 1:05 pm
You can do this by one of two ways, backup/restore or detach/attach.
November 3, 2008 at 3:38 pm
but what happen with the version, is that, that simple? I mean, I need to upgrade from MSDE to SQL 2000, just to backup/restore ?
November 3, 2008 at 3:49 pm
What version is MSDE? Can you connect to it with QA? If so, do this: select @@VERSION and report the results.
November 4, 2008 at 5:50 am
It says version 8.00.760 Desktop Edition SP3.
November 4, 2008 at 7:03 am
That tells me that the version of MSDE you are running is SQL Server 2000 as well. All you need to do is a backup of the database on MSDE and then restore the backup to the SQL Server 2000 EE instance. The other way is to detach the database from the MSDE instance and attach it to the SQL Server 2000 EE instance. If you use the detach/attach, be sure to take a full backup first in case you have a problem with the files (get corrupted, accidently deleted, whatever).
The only other issue you may run into is logins. I'd read BOL about that. You may need to delete and recreate the logins and database users.
November 4, 2008 at 11:28 am
Thank you, so that means that I don't need to run any script? anything?, just because is under SP3?
November 4, 2008 at 11:44 am
Not sure what kind of script you are talking about. If there are any structure changes, SQL Server will handle that for you.
November 4, 2008 at 12:27 pm
Thank you Lynn,
I was asking because one of my partners told me that I need to run queries, scripts...in order to upgrade my MSDE SP3 to SQl 2000, I didn't find anything like that, but my partner was insisting me, and I just want to be sure.
Thank you much.
November 4, 2008 at 12:55 pm
One more thing??? MSDE SP3 means that I am already under SQL 2000 EE?, or able to do just a backup/restore?
November 4, 2008 at 1:01 pm
What I got from the version is that you are using the same base code. Your version of MSDE wasn't SQL Server 7.0 or (7.5). You still would have been able to do a backup/restore or detach/attach as SQL Server 2000 is backward compatible. You just would have to change the compatability mode of the data base to make use of SQL Server 2000 enhancements if MSDE was SQL Server 7.0/7.5 based. Not necessary here as both are SQL Server 2000.
November 4, 2008 at 3:15 pm
Thanks for all your help!
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply