SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Which version do I install
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 01/24/2014 :  11:01:33  Show Profile  Reply with Quote
Hi

I 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.

Thanks

David

James K
Flowing Fount of Yak Knowledge

3761 Posts

Posted - 01/24/2014 :  11:54:01  Show Profile  Reply with Quote
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.

Edited by - James K on 01/24/2014 11:54:34
Go to Top of Page

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 01/25/2014 :  04:27:25  Show Profile  Reply with Quote
I only have a choice of those 4 options. I presume option 1 would be the most appropriate for my needs?
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17681 Posts

Posted - 01/25/2014 :  08:00:30  Show Profile  Reply with Quote
quote:
Originally posted by dnf999
I 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
Time is always against us

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000