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

Answer 1

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

Answer 2

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.