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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Upgrade

Author  Topic 

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2007-08-08 : 06:27:45
What's the easiest way to upgrade from SQL Express 2005 to SQL Server 2005?

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-08 : 06:34:51
Uninstall and install.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2007-08-08 : 06:45:51
how do you get the databases from sql express? backup and restore?
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-08 : 07:11:27
Yep.
You can detach them and attach after the install but you should have backups in case that fails.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2007-08-08 : 10:29:26
sorry, that was a stupid question
thanks
Go to Top of Page
   

- Advertisement -