Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
which sql server and visual studio

Answered which sql server and visual studio

  • Saturday, February 16, 2013 10:13 PM
     
     
    Sign In to Vote
    0

    I need to use SQL SERVER 2008, My computer is 64 and Service Pack 1!
    My doubts are

    1. Should i download r2 or just sql server 2008 to connect my databases in Visual studio? ( Need to open tables and create... in Visual studio!!)
    2. Which should i download?i have the following with me already!
    • SQLEXPRADV_x64_ENU
    • SQLEXPRDAV_x64_ENU
    • SQLEXPRWT_x64_ENU
    • SQLEXPR_x64_ENU
    • SQLServer2008R2SP1-KB2528583-IA64-ENU
    • SQLServer2008R2SP1-KB2528583-X64-ENU
    • SQLManagementStudio_x64_ENU
    • SQLServer2008SP1-KB968369-IA64-ENU
    • SqlSP1_setuphelp
    • SQLServer2008SP1-KB968369-x64-ENU
    1. Will installing multiple instances create a problem?

    Pls help me at the earliest, i am a newbie and a student trying to create a visual studio project.
    Thank you


    • Moved by Bob BeaucheminMVP Sunday, February 17, 2013 5:20 AM Moving to the setup forum for best response
    •  
     

All Replies

  • Sunday, February 17, 2013 6:32 AM
    Moderator
     
     Answered
    Sign In to Vote
    2

    Hello,

    If you are using Visual Studio 2010, this VS is intended to work with any edition of SQL Server 2008 R2. SQL Server 2008 databases can be used also.

    If you are using VS 2008, then install any edition of SQL Server 2008. SP1 for SQL Server 2008 is required.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


     
  • Sunday, February 17, 2013 10:31 AM
    Moderator
     
     Answered
    Sign In to Vote
    2

    Creating multiple instance should not create a problem

    I recommend installing SQLEXPRDAV_x64_ENU or SQLEXPRWT_x64_ENU

    for complete reference on feature per SQL server edition please see

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

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    • Marked As Answer by ahla haroon Sunday, February 17, 2013 1:54 PM
    •  
     
  • Sunday, February 17, 2013 1:53 PM
     
     
    Sign In to Vote
    0

    Thanx a lot @alberto sir and @ahmed sir,

    I will surely try installing and give you the feedback!

    Thank you to all a lot in advance :)


    • Edited by ahla haroon Sunday, February 17, 2013 3:20 PM
    •  
     
  • Sunday, February 17, 2013 2:03 PM
     
     
    Sign In to Vote
    0
    also if i install SQLEXPRWT,
    then when i install SQL MANAgEMENT STUDIO,
    It should be created as another instance right?

    My Basic need is to create databases in visual studio!!!
     
  • Sunday, February 17, 2013 4:12 PM
    Moderator
     
     
    Sign In to Vote
    1

    Hello,

    Visual Studio allows you to create a SQL Server Express instance from the Visual Studio setup. Probably you have installed Express Edition. Please run the Discovery Report to see what you have already installed:

    http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx

    The following article may help you create your first database:

    http://msdn.microsoft.com/en-us/library/ms233763(v=vs.90).aspx

    http://msdn.microsoft.com/en-US/library/ms171884(v=vs.90).aspx

    http://www.codeproject.com/Articles/235202/Creating-a-database-project-with-Visual-Studio

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com