none
Visual Studio 2015 - cannot save tables in Service-Based Database

    Question

  • In Visual Studio 2015 I create a new 'Service-Based' database

    I edit the database (create tables and add data)

    When I want to save the table, I select 'Save All"

    VS 2015 then prompts me where I want to save 'dbo.Table.sql' and its default save location is My Documents

    The same exact thing is happening when I connect to a database in SQL express.

    Why cant I save my tables ????

    Thank you in advance !!!

    Brandon



    • Moved by Asha99 Sunday, December 20, 2015 6:45 AM related VS2015
    Friday, December 18, 2015 4:26 AM

Answers

  • Hi Brandon,

    Thanks for your post.

    I have encountered this problem before. The root cause of the problem might be you haven’t updated your database.

    After click Update button, then click Update database button .Refresh your Tables then your table will be saved and you can see the table:

    Best Regards,

    Lake Xiao

    Tuesday, December 22, 2015 6:36 AM
    Moderator

All replies

  • Hi Brandon,

    Thanks for your post.

    I have encountered this problem before. The root cause of the problem might be you haven’t updated your database.

    After click Update button, then click Update database button .Refresh your Tables then your table will be saved and you can see the table:

    Best Regards,

    Lake Xiao

    Tuesday, December 22, 2015 6:36 AM
    Moderator
  • Hi Brandon,

    Have your issue solved?

    If you have any update. Please feel free to share here.

    Best Regards,

    Lake Xiao

    Tuesday, December 29, 2015 6:46 AM
    Moderator
  • Lake

      So sorry for the delay.  Yes that was the fix !!!  Thank you very much for your time

    Best Wishes

    Brandon

    Friday, January 22, 2016 5:05 AM
  • Well I see that using the update tool creates the database just like you showed above.  

    But now how do I rename the table 

    Thank you

    Brandon

    Friday, January 22, 2016 6:03 AM
  • Hi Brandon,

    Sorry for the late reply.

    Since one issue for one thread. If possible. Please post a new thread for your new question. Then we will follow up it.

    Thanks for your understanding.

    Best Regards,

    Lake Xiao

    Monday, January 25, 2016 1:45 AM
    Moderator