locked
VS10 - Schema compare between DB and DB Project -

    Question

  • I am syncing a pre-existing database project with a physical database. Most objects sync with no issues.  But for new procedures, it does not seem to be placing the files within the tree structure where all the pre-existing stored procedured already exist.  But if I view via the schema explorer, the new procedures are listed.  The issue is with the solution explorer, and all the objects are not within the correct tree structure.

    It just seems to happen for procedures.  Any one have any thoughts on this??

     


    Mark
    Wednesday, May 12, 2010 8:59 PM

Answers

  • Hi Mark,

    This is typically caused by the Stored Procedures dir missing or not in the intended location.  Check and make sure the directory exists. If this is an upgraded project, it is probably caused by the old layout/or a different organzation being used.

    <ProjectName>
            \Properties
            \References
            \Data Generation Plans
            \Schema Objects
            \Database Level Objects
             \Schemas
                     \dbo
                          \Programmability
                               ....
                             \Stored Procedures
                      .....
                      \Views
            \Scripts


    Barclay Hill Program Manager Visual Studio Data Tools (DataDude, DBPro, Database Edition, Database Projects, VS Data Tools) Please mark the responses as the answer if it resolves your question/issue. http://blogs.msdn.com/bahill
    Thursday, May 13, 2010 4:40 PM
    Moderator

All replies

  • Hello Mark,

    Based on your descriptions, you are doing schema compare and the physical database as source which has some new SP, after compare, you find that in the solution explorer, you are not able to find the defition file while you could find it in schema view. If so, could you please click the Refresh button in the tool bar for solution explorer to see if it shows up, in addition, in the schema view, you may open the new SP to see if it adds well.


    Edwer Fang [MSFT]
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg @ microsoft.com

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Send us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.
    Thursday, May 13, 2010 9:43 AM
    Moderator
  • Hi Mark,

    This is typically caused by the Stored Procedures dir missing or not in the intended location.  Check and make sure the directory exists. If this is an upgraded project, it is probably caused by the old layout/or a different organzation being used.

    <ProjectName>
            \Properties
            \References
            \Data Generation Plans
            \Schema Objects
            \Database Level Objects
             \Schemas
                     \dbo
                          \Programmability
                               ....
                             \Stored Procedures
                      .....
                      \Views
            \Scripts


    Barclay Hill Program Manager Visual Studio Data Tools (DataDude, DBPro, Database Edition, Database Projects, VS Data Tools) Please mark the responses as the answer if it resolves your question/issue. http://blogs.msdn.com/bahill
    Thursday, May 13, 2010 4:40 PM
    Moderator