Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 move data to new SQL Server

Author  Topic 

peterswan
Starting Member

8 Posts

Posted - 2011-02-23 : 11:51:33
Hello,

My evaluation copy of SQL Server 2005 just expired and I'm about to install SQL Server Developer Edition 2005. I want to copy all of the data from the expired Eval Edition over to the new Developer Edition. Does anyone know the best way to do this?

Thanks,

Peter

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-02-23 : 11:57:03
Try to attach the database files, that should work.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

peterswan
Starting Member

8 Posts

Posted - 2011-02-23 : 12:30:38
During the install of 2005 it says it can't start the SQL Server Services (I assume from the Eval copy I also have installed). So maybe I need to uninstall Eval first, then install Development version. Is this right?
Go to Top of Page

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2011-02-24 : 07:23:58
It would seem so.
See if this blog helps.

http://blogs.msdn.com/b/sanchan/archive/2006/07/27/681086.aspx
Go to Top of Page

peterswan
Starting Member

8 Posts

Posted - 2011-02-25 : 11:46:20
thanks for the help. I had to save the data files on another drive (about 80 gig) then uninstall Eval. After the new install of 2005 Developer, I attached the old MDF files and now the data is successfully installed. Right now I'm re-creating my old logins, which hopefully will bring me back to normal. If anyone else can think of anything I've missed, please let me know.

Thanks,

Peter
Go to Top of Page

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2011-02-28 : 07:57:07
Any SQL Agent jobs, linked servers will need to be recreated aswell.
Go to Top of Page
   

- Advertisement -