none
How should I right publish my SQL-Database project (VS 2017 Community) on live system? RRS feed

  • Question

  • Hello,

    actually I publish my SQL-Database project (VS 2017 Community) as follow:

    1. I set all "create stored procedures" sql-scripts properties "Build" on "none"

    2. I Set all "create tables" sql-scripts properties "Build" on "none"

    3. Then I make a changes in one stored procedure, which I will change on live system

    4. Then I set a Property "Build" of  this procedure at "Build"

    5. finally I start my live-publish.xml and click auf "publish.

    So I achieve a goal, that my live database will not complete rewrited, but only one script, that I wish.

    Question:

    Is it possible to make the same simply? (in one or two steps?)

    Thanks.

    P.S.

    in VS 2010 I should make only right click on procedure, and then publish it on live- or test-system.


    Tuesday, June 18, 2019 10:39 AM

All replies

  • SOLVED: Doubleclick on SP, connect to Server, run.
    Tuesday, June 18, 2019 11:38 AM
  • Hi Interraptor,

    I’m glad to hear that you got it working.

    Thank you for sharing your solution here. It will be very beneficial for other community members who have similar questions.

    Have a nice day.

    Best Regards,

    Dylan


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, June 19, 2019 6:39 AM