Modify Local Database

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.

Answer 1

User-821857111 posted

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

Answer 2

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.

Answer 3

User-821857111 posted

You need to use SSMS 2012.