Post reply

can you use SQL Server 2012 Management Studio Express for an sql2008 database?

  • June 25, 2012 at 10:27 am

    #258041

    can you use SQL Server 2012 Management Studio Express for an sql2008 database?

    Thanks!

  • June 25, 2012 at 12:07 pm

    #1505226

    Yes, you connect to a SQL Server 2008 instance using SQL Server Management Studio 2012.

    Have you tried it in your environment and it did not work? Or are you just doing research? Why do you ask?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • June 25, 2012 at 1:22 pm

    #1505255

    Yes you can. I, for example, use ssms 2008 for sql server 2005, and ssms 2012 for sql server 2008.

    Express version is with some restrictions

    http://technet.microsoft.com/en-us/library/ms365247(v=sql.105).aspx

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • June 25, 2012 at 3:41 pm

    #1505304

    You should be able to - but, since it is an Express version I am not sure whether or not it will work. If it does work, it will be limited in the features available.

    You can always download it and test it out yourself.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • June 25, 2012 at 6:30 pm

    #1505340

    Working on an MVC 4 and MVC4 mobile project.

    I ask because I only want to put sql 2012 express with management studio express on a dev machine, but want it also to be able to connect to an sql 2008 engine on another machine.

    SO if I could not do that, than I would have had to install 2008 management studio as well.

    Thanks.

  • June 25, 2012 at 7:16 pm

    #1505344

    As long as you aren't too concerned with connecting to SSAS/SSIS/SSRS or using SQL Server Agent, you shouldn't have any major issues (there are still a handful of things you can't do with SSMSE).


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply