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)
 Upgrading 2K5 Express edition to 2K5 standard,Help

Author  Topic 

JKurz
Starting Member

1 Post

Posted - 2009-12-01 : 19:25:59
Hey Guys and gals,

We have server running SQL express 2005 advanced, and I just purchased a copy of SQL 2K5 standard. We do run SAP Business one (ERP) using the sql express. (Very little data)

What is the most painless way to upgrade to SQL standard?

Sorry if this is a dumb question as we are a very small company with no IT resources.

Thanks

-Jon

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-02 : 00:07:01
You'll need to install an instance of standard edition and then move your databases between the two databases. I recommend using backup/restore or detach/attach. I do not recommend the copy database wizard since that does not give you the exact same databases.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

emg78
Starting Member

5 Posts

Posted - 2009-12-22 : 12:45:43
I have a server running sql server standard 2005 edition.
On that server i have an instance that is using sql express. How can i upgrade that instance to sql standard?
is there a tool?
note:
the express instance was express from beginning and migrated from 2000 or 7.0

thanks
Go to Top of Page

emg78
Starting Member

5 Posts

Posted - 2009-12-22 : 12:47:05
Im sorry instance was not migrated from 2000 or 7.0
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-22 : 13:02:56
See my above post.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

emg78
Starting Member

5 Posts

Posted - 2009-12-22 : 14:13:44
Theinstance will be different...How can I change instance name to original?Or can I...

thanks for the quick response

Go to Top of Page

emg78
Starting Member

5 Posts

Posted - 2009-12-22 : 14:18:24
also im not a sql guru...lol
how do i create an instance name or database?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-22 : 14:32:56
You have to install it. You can't change an instance name.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

emg78
Starting Member

5 Posts

Posted - 2009-12-23 : 08:35:10
Can you guide me as to where I can get install guide to install and create a new instance along with any other documentationfor maintaining & asministrating SQL?
I would like to learn more about SQL

thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-23 : 13:23:28
I don't have any such documentation.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -