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.
| 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. |
 |
|
|
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? |
|
|
|
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 |
|
|
|
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 |
|
|
|
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. |
|
|
|
|
|
|
move data to new SQL Server