April 14, 2009 at 10:41 am
Noob here.
I have one server that has SQL Server 2005 Enterprise on it.
Is it true that I can't "upgrade" this instance to SQL Server 2008 Standard?
What is my best solution for doing this?
Can I just do an "install" of SQL Server 2008 Standard on this server and port the databases over manually?
If I do, the instance name would have to be different on the 2008 instance. If after I get everything ported, can I remove the 2005 instance and then rename the 2008 instance to the name of the server and be the default instance?
Gary
April 14, 2009 at 5:35 pm
The most important features differences in SQL Server editions is in BI stack and replication, if you are not using both install the 2008 standard and move databases and objects.
Kind regards,
Gift Peddie
April 15, 2009 at 10:04 am
Thanks, so i should no problem with having the name of the 2008 instance being the machine name when I'm done?
April 15, 2009 at 10:27 am
If remember correctly name of instance is not relevant because since 2000 days some shops only installs named instances. And in 2005 you could change the name of the instance as needed. So run tests with the migration in a test box resolve issues then migrate.
Kind regards,
Gift Peddie
April 16, 2009 at 3:14 am
Check these links How to Upgrade to SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms144267.aspx
http://msdn.microsoft.com/en-us/library/bb677622.aspx
I hope these links might be helpful
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply