locked
SQL Server Compact Edition Support for SQL Server Management Studio 2012 RC0 RRS feed

  • Question

  • All:

       I am working with SQL Server Management Studio 2012 Release Candidate #0 and noticed that "SQL Server Compact" is not an option in the "Server Type" dropdown box.

       Is there any plans to support SQL Server Compact 3.5/4.0 databases in SQL Server Management Studio 2012?


    Master VB Guru
    Friday, January 6, 2012 3:28 PM

Answers

  • No, managing SQL Server Compact has been dropped from Management Studio, use Visual Studio instead.
    Please mark as answer, if this was it. Visit my SQL Server Compact blog
    • Proposed as answer by Warwick Rudd Monday, January 9, 2012 8:06 PM
    • Marked as answer by amber zhang Friday, January 13, 2012 8:25 AM
    Monday, January 9, 2012 10:51 AM
  • Hi MasterVBGuru,

    >> Is there any plans to support SQL Server Compact 3.5/4.0 databases in SQL Server Management Studio 2012?

    As AnupSivaDas mentioned, SQL Server Management Studio 2012 supports for SQL Server Compact 3.5.

    Regarding to your description, there was no option to connect to SQL Server Compact from the Database Engine connection interface.

    Based on my lab, there is indeed an option to connect to SQL Server Compact from a query. This needs to be enabled before you can run a query, please try to follow the steps as below:
    Click View >>Toolbars >>SQL Server Compact Edition Editor as shown.


    Based on my research, it seems that the SQL Server Management Studio cannot open SQL Server Compact 4 files, only SQL Server Compact 3.5 files.

    However there is a workaround for you, please try to use Visual Studio 2010 SP1 + VS Tools for SQL CE 4.
    Optionally in combination with the tool, you can download from here: http://sqlcetoolbox.codeplex.com

    More information, please refer the Blog: http://erikej.blogspot.com/2010/12/visual-studio-tools-for-sql-server.html

    If you have any problem, please let me know.


    Regards,
    Amber zhang

    TechNet Subscriber Support

    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.



    • Edited by amber zhang Tuesday, January 10, 2012 1:03 AM
    • Marked as answer by amber zhang Friday, January 13, 2012 8:25 AM
    Monday, January 9, 2012 2:59 AM
  • Use my SQL Server Compact Toolbox in VS 2013...

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    • Marked as answer by Kevin Kingma Thursday, October 24, 2013 11:41 AM
    Thursday, October 24, 2013 9:36 AM
  • Install it from the Tools, Extensions dialog in VS 2013.


    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    • Marked as answer by Kevin Kingma Thursday, October 24, 2013 11:41 AM
    Thursday, October 24, 2013 11:10 AM

All replies

  • As per my understanding Compact edition will be available only after 2012 is released.

    Thank you,

     


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Friday, January 6, 2012 6:50 PM
  • Hi MasterVBGuru,

    >> Is there any plans to support SQL Server Compact 3.5/4.0 databases in SQL Server Management Studio 2012?

    As AnupSivaDas mentioned, SQL Server Management Studio 2012 supports for SQL Server Compact 3.5.

    Regarding to your description, there was no option to connect to SQL Server Compact from the Database Engine connection interface.

    Based on my lab, there is indeed an option to connect to SQL Server Compact from a query. This needs to be enabled before you can run a query, please try to follow the steps as below:
    Click View >>Toolbars >>SQL Server Compact Edition Editor as shown.


    Based on my research, it seems that the SQL Server Management Studio cannot open SQL Server Compact 4 files, only SQL Server Compact 3.5 files.

    However there is a workaround for you, please try to use Visual Studio 2010 SP1 + VS Tools for SQL CE 4.
    Optionally in combination with the tool, you can download from here: http://sqlcetoolbox.codeplex.com

    More information, please refer the Blog: http://erikej.blogspot.com/2010/12/visual-studio-tools-for-sql-server.html

    If you have any problem, please let me know.


    Regards,
    Amber zhang

    TechNet Subscriber Support

    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.



    • Edited by amber zhang Tuesday, January 10, 2012 1:03 AM
    • Marked as answer by amber zhang Friday, January 13, 2012 8:25 AM
    Monday, January 9, 2012 2:59 AM
  • No, managing SQL Server Compact has been dropped from Management Studio, use Visual Studio instead.
    Please mark as answer, if this was it. Visit my SQL Server Compact blog
    • Proposed as answer by Warwick Rudd Monday, January 9, 2012 8:06 PM
    • Marked as answer by amber zhang Friday, January 13, 2012 8:25 AM
    Monday, January 9, 2012 10:51 AM
  • How do you get this toolbar as an option? It does not appear for my installation...
    Friday, August 24, 2012 11:46 AM
  • I think the screenshot is from SSMS 2008, not SSMS 2012.

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    • Proposed as answer by P H T Wednesday, April 17, 2013 8:13 PM
    Friday, August 24, 2012 12:57 PM
  • it is dropped in vs2013 also...
    Thursday, October 24, 2013 8:21 AM
  • Use my SQL Server Compact Toolbox in VS 2013...

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    • Marked as answer by Kevin Kingma Thursday, October 24, 2013 11:41 AM
    Thursday, October 24, 2013 9:36 AM
  • Hi Erik:

        Can you send me a link to the new version that works with Visual Studio 2013?  When I go to the download page for version 3.6, it says there are no files available for download.


    Master VB Guru

    Thursday, October 24, 2013 11:08 AM
  • Install it from the Tools, Extensions dialog in VS 2013.


    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    • Marked as answer by Kevin Kingma Thursday, October 24, 2013 11:41 AM
    Thursday, October 24, 2013 11:10 AM