Solved

sql express 2012 installation

Posted on 2014-01-31
3
328 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
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 250 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 250 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

831 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