Keep SQL Server 2005 with Visual Studio 2008

Posted on 2009-12-17
Last Modified: 2013-11-26
Hi, we are about to upgrade our visual studio 2005 professional to visual studio 2008 professional (a little late, I know), and I was wondering if it is a requirement to upgrade also sql server 2005 to sql server 2008?
All our applications has been written in visual studio 2005 and use the sql server 2005 as the backend DBMS.
Could we keep sql server 2005 and continue developing our applications using visual studio 2008 now?
Question by:THEtechadmin
    LVL 14

    Accepted Solution

    Yes you can run any sqlserver from vs2008.

    as long as you have the proper connections to the database you will be fine.
    Many people have done this.

    LVL 74

    Expert Comment

    by:käµfm³d 👽
    Visual Studio is just the IDE (same way Eclipse and CodeBlocks are IDEs). There is nothing tying VS to Sql Server. You could write code to connect to Sql Server in Notepad and compile it using the command line if you wanted.

    So the short answer to your question is, yes, you can use VS '08 with SS.  :)
    LVL 74

    Expert Comment

    by:käµfm³d 👽
    >> There is nothing tying VS to Sql Server.

    For clarity, should read:

        There is nothing tying any particular version of VS to any particular version of Sql Server.

    Author Closing Comment

    Thank you very much everyone for the prompt answers.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now