Solved

sql express 2012 installation

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now