locked
Db Projects don't persist/remember open objects from Data Connections

    Question

  • I have to be missing something here.  Let's say I have a couple of Views open, and a couple of Stored Procedures open--all from Server Explorer's Data Connections.  I want to be able to close my VS Db project and reopen it later to resume working on the four db objects.  I want VS to remember/persist what objects I had open.  It sounds so simple, yet I can't make VS do it.

    Further, I don't just want the last items I had open, I want VS to persist open Data Connection objects in my Db project "work space"--just like Visual Studio "Projects" do for open "objects".  In other words, I can have multiple "sets" of database objects ("projects") that I can re-open to resume work.  I work in design views, so I want more than just "scripts."

    Please tell me what I'm missing.  This seems ridiculous.


    , Lee

    Tuesday, March 27, 2012 4:23 PM

Answers

  • Hello Lee,

    Based on your description, it seems that you would like to re-open these already opened database objects in the Server Explorer once you re-open the VS. As far as I know that your requirement is unachievable. As we know that VS can remember these previously opened files of a solution or project, that is because all the information is stored in the .suo file. However, I do not think there is any setting or feature available in the VS to store the information for the objects in the Server Explorer.

    I think you can consider submitting one feature request on the Microsoft UserVoice site here:

    http://visualstudio.uservoice.com/forums/121579-visual-studio

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, March 28, 2012 3:15 AM
    Moderator

All replies

  • Hello Lee,

    Based on your description, it seems that you would like to re-open these already opened database objects in the Server Explorer once you re-open the VS. As far as I know that your requirement is unachievable. As we know that VS can remember these previously opened files of a solution or project, that is because all the information is stored in the .suo file. However, I do not think there is any setting or feature available in the VS to store the information for the objects in the Server Explorer.

    I think you can consider submitting one feature request on the Microsoft UserVoice site here:

    http://visualstudio.uservoice.com/forums/121579-visual-studio

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, March 28, 2012 3:15 AM
    Moderator
  • Perhaps SSDT is step in the right direction.  I'm about to try it out.

    http://msdn.microsoft.com/en-us/data/tools.aspx


    , Lee C.

    Friday, March 30, 2012 4:03 PM