Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

SQL express to full SQL upgrade

We are developing a Windows app in c# using Windows Sql Express 2013 that will run in a 10 user Windows Workgroup The office and budget is too small for a domain and server.
 
The database will reside on it’s own dedicated Win7 box. At some time in the future, if we see the db is growing to capacity, what’s the safest manner of upgrading to full sql and can it be done on Win 7 pro?
0
Tony Giangreco
Asked:
Tony Giangreco
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
safest: backup the databases, install the full sql aside as dedicated instance, and restore the databases (and any server-side stuff like logins, linked servers etc ...) on that new instance. once you confirmed that all is working fine, you can uninstall that express instance.
0
 
sunnykguptaCommented:
Hey,

You can easily migrate Sql Express to SQL Server.

When installing Workgroup or Standard it will upgrade the database server and the databases at the same time. Make sure you have a backup of your database (just in case). You can always backup the database and restore it to Workgroup or Standard as well.

Here's a guide: http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=55
0
 
Tony GiangrecoAuthor Commented:
Great Suggestions. Thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now