none
difference between 2 ways of create database in visual studio

    Question

  • hello what the different between those 2 ways

    1-right click--->add new item--->sql server database this will generate database with .mdf

    the other way is

    2-server explore and connect with sql application u already created there this will generate .dbo

    what is the difference

    Thank you. 

     
    Thursday, March 2, 2017 3:05 PM

All replies

  • Hi NVS37,

    According to your description,

    First, we could use add item to generate database item.

    Second, we could use server explorer to connect the database to create tables and query data.

    There is no difference in creating local database. But when we create a database with add item, we could only create a loadDB database, but if we want to create a database from SQL Server, we need to connect the Sql Server first then crate it.

    Hope it helpful for you.

    Sincerely,

    Oscar


    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.

    Friday, March 3, 2017 2:46 AM
    Moderator
  • Hi my friend,

    If my reply help you resolved your doubts, please remember to mark it as answer, which could be helpful for others who has the same doubts. Thank you very much :)

    Sincerely,

    Oscar



    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.

    Monday, March 6, 2017 9:03 AM
    Moderator