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
 General SQL Server Forums
 New to SQL Server Programming
 Set Up Database in Visual Studio Express 2010

Author  Topic 

vodkasoda
Starting Member

15 Posts

Posted - 2010-04-16 : 02:52:58
I have found a tutorial that will teach me how to set up my first Database in Visual Studio Express 2010, but the first thing it tells me to do is right-click on the Data Connections Icon within Database Explorer and choose "Create New SQL Server Database" ... unfortunately, this option is greyed out, so I am assuming I have to choose "Add Connection" first ...

This gives me 3 options :

  • Microsoft Access Database File

  • Microsoft SQL Server Compact 3.5

  • Microsoft SQL Server Database File


I am ignoring the first option as I want to use SQL not Access, but what is the difference between the two SQL options ?!?

Can somebody please let me know, in straightforward English ?!?

Thanks in advance ...

Sachin.Nand

2937 Posts

Posted - 2010-04-16 : 03:07:59
Well in straightforwards English

Microsoft SQL Server Compact 3.5 is compact edition of SQL server used to make mobile applications that can run on all Windows platforms including Pocket PC, and Smartphone.

Microsoft SQL Server Database File is used if you want to make a connection to an .mdf file.




PBUH
Go to Top of Page

vodkasoda
Starting Member

15 Posts

Posted - 2010-04-16 : 04:55:12
At last, somebody able to answer a straightforward question, thank you, I must now bookmark this forum !!!

Thank you, no doubt I will be back with plenty more questions, but at least I can get started now ...
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-04-16 : 05:17:18
Well you are always welcome.
There are lot geniuses(with exception of me of course )in this forum who can help you in any of your queries related to SQL Server.

PBUH
Go to Top of Page
   

- Advertisement -