?
Solved

sql express 2012 installation

Posted on 2014-01-31
3
Medium Priority
?
358 Views
Last Modified: 2014-02-11
Hello experts,

I need migrate foxpro database into SQL express 2012.  Now one PC (win7) working as a server and another person is connected to it. I'm thinking about some separate box for SQL instance and two clients will be connected to it.

Based on your experience what I should choose for hardware:
- win 7 pro powerful workstation
or
-some simple server with windows 2008 r2

Only two people will be connected to this machine and working with database. Not sure if is any reason to spend money on server if workstation can handle it.
I'm planning install SQL server 2012 express.
By the way, database is not very big, after conversion should be around 1GB.
thanks for any comments

henry
0
Comment
Question by:henryk123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Expert Comment

by:ktaczala
ID: 39824127
That would be fine.
0
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 1000 total points
ID: 39824286
any one of the above should be fine..

but I prefer to install it on windows server, as two people can simultaneously login into the server, but not on a server...
Remember I am not talking about SQL Server here, but the windows server OS itself.
0
 
LVL 7

Accepted Solution

by:
XGIS earned 1000 total points
ID: 39824674
Hello henryk123..
Even xp allow 10 simultaneous connections.
Windows 7 Pro is fine and it handles SQL well, as long as you have enough ram.
x64 is probably better but not required if you only have x32
sql 2012 with management studio is fine for dbs up to 10gb.
you can run a web application through IIS if they just need to edit data. then you can have a bunch of users
eg hkvstore  aspnetmaker to auto generate your interface and publish the website.. Fully functional for 30 days and relatively cheap for the amount of work it does, unlike some code generators.
really easy to work and manage whilst ensuring security of your data, even if it is running off a laptop.
Cheers and Good Luck
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question