locked
Modify Local Database RRS feed

  • Question

  • User931778073 posted

    Hi All,

    I've created an MVC 4 project in VS2012 which automatically created options for registering and logging-in. The membership info created during the registration process is stored on a local database. I have added more tables to this database and would like to create relationships between the tables but I don't know if there is a way to do it other than through scripts using SQL Server Data Tools (SSDT). I wanted to open this database up in SSDT or SQL Server Management Studio (SSMS) then create their relationships there. However, thus far I have yet to read that SSDT has options for creating relationships between tables. Also, it does not appear there is  a way to locate the localdb database  from within SSMS.  Please point me in the right direction, thanks in advance.

    Tuesday, November 12, 2013 10:03 PM

Answers

  • User-821857111 posted

    You need to use SSMS 2012.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 13, 2013 1:44 AM

All replies

  • User-821857111 posted

    When connecting in SSMS, specify (localdb)\v11.0 as the server name.

    Wednesday, November 13, 2013 12:52 AM
  • User931778073 posted

    Hello and thanks for the reply. I was able to open the database but now when I try to open any of the tables, I get the error :

    "This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)"

    Please help me resolve the problem, thanks.

    Wednesday, November 13, 2013 1:01 AM
  • User-821857111 posted

    You need to use SSMS 2012.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 13, 2013 1:44 AM