My question is similar to this, but I don't have a "real" Server only localdb from Microsoft SQL-Server Express:
how can i see data in mdf file
I have a (closed) tool I need to export data from to import it with groovy into a web application. The instructions said to download "Microsoft SQL-Server Express 2012 LocalDB". I installed it and everything works fine, I was never asked to enter a DB Name, Username or Password.
Now I have to change some data inside the mdf file but I have no idea how, I never worked with any Microsoft SQL Products. Basically a standard sql console would be enough for me.
In the linked question it was suggested to link the file in Microsoft SQL Server Management Studio, however I am asked for a server name and can't connect to localhost.
Can I connect the Management studio to the localdb? Or is there any way to execute simple sql commands on the mdf file or anything else I can do?
Marc B was right:
Install both "Microsoft SQL-Server Express 2012" and the tools, attach the file, and you can execute any SQL commands inside the Microsoft SQL Server Management Studio. Overall I hope I never have to use this again :)