Differences between R2 and Express

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Differences between R2 and Express

Author

Topic

Philosophaie
Starting Member

3 Posts

Posted - 2013-06-01 : 04:39:24

What is the differences between:

SQL Server 2008 R2

and

SQL Server 2008 Express.

And if I may, what are the corresponding Connection Strings for each.

A typical Connection String for R2 is:

Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword;

myDatabase would be "../AppData/mydb.mdf

Could you give me some examples of "myServerAddress".

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-01 : 05:53:16

SQL 2008 express is free version of sql server available for small application usage. it has some limitations compared to standard editions

see below for feature comparison

http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx

SQL 2008 R2 is next major release of SQL Server product after 2008. its also available in various editions like express,standard,enterprise etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-01 : 09:23:55

quote:
Originally posted by Philosophaie

What is the differences between:

SQL Server 2008 R2

and

SQL Server 2008 Express.

And if I may, what are the corresponding Connection Strings for each.

A typical Connection String for R2 is:

Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword;

myDatabase would be "../AppData/mydb.mdf

Could you give me some examples of "myServerAddress".

Take a look at connectionstrings.com. It has the most comprehensive list of connection strings that I am aware of.

Philosophaie
Starting Member

3 Posts

Posted - 2013-06-01 : 12:24:29

Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword;

myDatabase would be "../AppData/mydb.mdf

Could you give me some examples of "myServerAddress".

Something like:

"..\sqlr2\folder\"

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-01 : 12:49:43

If you have Express edition, YourComputerName\SQLExpress. If you are on the same computer as where SQL is installed - which is likely in your case - you could also use: .\SQLExpress

You can find your computer name by looking it up in the My Computer Properties, (on windows 8 Settings -> Properties), or open a command window, run "ping -a 127.0.0.1"

If you have non-express edition, remove the \SQLExpress part. So it will be either . or YourComputerName.

This assumes you have installed the SQL as the default instance (which is likely the case).

You will notice that we are not specifying a file name or a path. We are trying to connect to the SERVER and then letting the server figure out where the database files.

Philosophaie
Starting Member

3 Posts

Posted - 2013-06-02 : 07:38:19

I have SQLServer 2008 R2. What would myServerAddress be for that?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-03 : 02:25:11

it should be YourServerMachineName if its a default instance or YourServerMachineName\InstanceName if its a named instance

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources