Variants of SQL Server
-
this is a newbie question: I'm trying to download and install Microsoft SQL Server Express 2008. When I search the Net (MSDN included), i see several listings and variants of the name: 1) MS SQL Server Express 2008 2) SQL Server 2008 R2 Express 3) SQL Server Management Studio Express 4) MS Server 2008 R2 others... Is there a difference between 1) and 4)? (32/64 bit variations??) 3) SQL Server Management Studio Express look good as an "all-arounder" (manage users, etc...) Would you recommend? * What is the most current Microsoft SQL Server? * What is the most current FREE Microsoft SQL Server? Thank you for helping me understand this. Regards, JJM
-
this is a newbie question: I'm trying to download and install Microsoft SQL Server Express 2008. When I search the Net (MSDN included), i see several listings and variants of the name: 1) MS SQL Server Express 2008 2) SQL Server 2008 R2 Express 3) SQL Server Management Studio Express 4) MS Server 2008 R2 others... Is there a difference between 1) and 4)? (32/64 bit variations??) 3) SQL Server Management Studio Express look good as an "all-arounder" (manage users, etc...) Would you recommend? * What is the most current Microsoft SQL Server? * What is the most current FREE Microsoft SQL Server? Thank you for helping me understand this. Regards, JJM
-
You should get SQL Server 2008 R2 Express WITH SQL Server Management Studio 2008 R2 (SSMS). See here : http://www.microsoft.com/express/database/[^] Choose the right version (32/64). Cheers
I don't like my signature at all
I was tending toward the "SQL Server Management Studio Express", but then was reading the WiKi for Microsoft SQL Server: http://en.wikipedia.org/wiki/Microsoft_SQL_Server[^] I will be using PowerShell at some point and some users are accustomed to working in Unix world with scripts (hence the PowerShell). PLUS, i think we're doing our development on the cheap (FREE version required). Does your suggestion still fit the bill? Thanks so much! John John
-
this is a newbie question: I'm trying to download and install Microsoft SQL Server Express 2008. When I search the Net (MSDN included), i see several listings and variants of the name: 1) MS SQL Server Express 2008 2) SQL Server 2008 R2 Express 3) SQL Server Management Studio Express 4) MS Server 2008 R2 others... Is there a difference between 1) and 4)? (32/64 bit variations??) 3) SQL Server Management Studio Express look good as an "all-arounder" (manage users, etc...) Would you recommend? * What is the most current Microsoft SQL Server? * What is the most current FREE Microsoft SQL Server? Thank you for helping me understand this. Regards, JJM
I agree with Estys that SQL Express R2 is the one to get, but I wanted to answer the question you had. The difference between 1 and 4 is that 4 is the MS Service 2008 R2 operating system and not a database. It is the OS for a server.
Steve Maier
-
I was tending toward the "SQL Server Management Studio Express", but then was reading the WiKi for Microsoft SQL Server: http://en.wikipedia.org/wiki/Microsoft_SQL_Server[^] I will be using PowerShell at some point and some users are accustomed to working in Unix world with scripts (hence the PowerShell). PLUS, i think we're doing our development on the cheap (FREE version required). Does your suggestion still fit the bill? Thanks so much! John John
Yes. SQL Server is the service needed to access your databases. The express editions are the free versions of it. There are limitations, for instance a 10GB maximum of data. SSMS is a management tool to perform maintenance on your DB's (located on various servers). Without it you're condemned to commandline tooling, nothing wrong with that but tedious for adhoc tasks. AFAIK Powershell is a prerequisite for SQL Server. For developement there is VS Express, also with limitations compared to the paid product. Cheers
I don't like my signature at all
-
I agree with Estys that SQL Express R2 is the one to get, but I wanted to answer the question you had. The difference between 1 and 4 is that 4 is the MS Service 2008 R2 operating system and not a database. It is the OS for a server.
Steve Maier
Cool! Thanks. I was thrown some loose requirements and some info on past configuration (maybe misquoted the past configuration, server/service,....) I am installing this on a Windows Server 2008 R2 64-bit system. Eventually, i'm going to be adding some features to integrate MS Access 2007, Visual C++ (Studio 2008 Ed) code, some stored procedures (which i think are created/reside in my C++ generated executable), PowerShell. Thanks all for the input and advice. Regards, John John
-
I was tending toward the "SQL Server Management Studio Express", but then was reading the WiKi for Microsoft SQL Server: http://en.wikipedia.org/wiki/Microsoft_SQL_Server[^] I will be using PowerShell at some point and some users are accustomed to working in Unix world with scripts (hence the PowerShell). PLUS, i think we're doing our development on the cheap (FREE version required). Does your suggestion still fit the bill? Thanks so much! John John
I think Express has a 4gb limit on the size of the database. Not generally a problem if you are aware of it!.
Never underestimate the power of human stupidity RAH
-
I think Express has a 4gb limit on the size of the database. Not generally a problem if you are aware of it!.
Never underestimate the power of human stupidity RAH
R2 has an increased limit (I hear).
-
You should get SQL Server 2008 R2 Express WITH SQL Server Management Studio 2008 R2 (SSMS). See here : http://www.microsoft.com/express/database/[^] Choose the right version (32/64). Cheers
I don't like my signature at all
Yes, that's the one to get.