Menu
I used to create all of my table relationships using database diagrams, but after installing VS2013, the feature seems to be missing. Was it removed completely, or can I turn it back on?
891
To open a database diagramIn Object Explorer, expand the Database Diagrams folder. Double-click the name of the database diagram you want to open. Right-click the name of the database diagram you want to open, and then choose Design Database Diagram.
If the explorer for your version of Visual Studio isn't open, choose View, Server Explorer or View, Other Windows, Database Explorer on the menu bar. Open the shortcut menu for Tables, and then choose Add New Table.
Database diagrams in xsd format can be opened in Visual Studio. Select main menu View > SQL Server Object Explorer to connect and view the desired SQL database objects. Connect using credentials to view database objects like Views, tables etc.
The SQL Server Data Tools (SSDT) is where you'll spend most of your time as an SSIS developer. It is where you create and deploy your SSIS projects. SSDT uses a subset of the full version of Visual Studio 2013.
Yes they have unfortunately
From http://msdn.microsoft.com/en-us/library/y5a4ezk9.aspx :
"In previous versions of Visual Studio, you could use Visual Database Tools to create tables, queries, and views, and to create and maintain database diagrams. In Visual Studio 2013, Visual Database Tools have been deprecated, but SQL Server Database Tools provide replacement features to help you create tables, queries, and views. See SQL Server Data Tools (SSDT).
Neither Visual Studio 2013 nor SQL Server Database Tools provide a replacement for database diagrams. You can use SQL Server Management Studio (SSMS) to work with database diagrams. SSMS is installed with SQL Server 2012 SP1 Express (download center)."
104
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
