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.
| Author |
Topic |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2014-01-24 : 11:01:33
|
| HiI would like to install SQL server on my machine and be able to run a database on my local machine (rather than connect to any network).Please could you advise which SQL server to install. My only options are:1. SQL Server 2012 Management Studio and Tools (v11.1.3000.0) 2. SQL Server Express 2008 (This does not give me the required local instance DB or management Studio!)3. SQL Developer (3.0.02.83 )4. SQL Server Management Studio 2008. (SQL Client and Management Studio software for SQL servers)My requirements are to upload data and query data on an ad-hoc basis. ThanksDavid |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-01-24 : 11:54:01
|
| Go to this page http://www.microsoft.com/en-us/download/details.aspx?id=29062 click on the download link.Download ENU\x64\SQLEXPRWT_x64_ENU.exe (or ENU\x64\SQLEXPRADV_x64_ENU.exe) If you are on 32 bit version get corresponding 32 bits)Either of these will give you management studio and the database engine.These are free versions. You could install developer edition, but the licensing agreement does not allow you to use it for production purposes. As for SQL 2008, you could install it, but SQL 2012 has everything SQL 2008 has and more, so I would go with SQL 2012. |
 |
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2014-01-25 : 04:27:25
|
| I only have a choice of those 4 options. I presume option 1 would be the most appropriate for my needs? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-01-25 : 08:00:30
|
quote:
Originally posted by dnf999I would like to install SQL server on my machine and be able to run a database on my local machine (rather than connect to any network).Please could you advise which SQL server to install. My only options are:1. SQL Server 2012 Management Studio and Tools (v11.1.3000.0) 2. SQL Server Express 2008 (This does not give me the required local instance DB or management Studio!)3. SQL Developer (3.0.02.83 )4. SQL Server Management Studio 2008. (SQL Client and Management Studio software for SQL servers)
(1) is not a SQL Server, it is a client tool(2) this is a SQL Server. However, you might required additional client tool to manage it(3) never heard of this. But when i do a search, i found a Oracle Developer. Don't think that is appropriate for SQL Server(4) Similar to (1), This is the client tool.You will either need (2) and (4) or go for the latest version SQL Server Express 2012 in the link that James provided
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Which version do I install