Menu
Create ER diagram in SSMSOpen SQL Server Management Studio (SSMS). In the Object Explorer on the left, expand your database. Right-click on Database Diagrams, and then select New Database Diagram.
Right click on the database containing the diagrams. Click on All Tasks then on "Export data". The Import / Export option will be displayed, click Next. Define the source and then click Next.
Yes you can use SQL Server 2008 itself but you need to install SQL Server Management Studio Express (if not installed ) . Just right Click on Database Diagrams and create new diagram. Select the exisiting tables and if you have specified the references in your tables properly. You will be able to see the complete diagram of selected tables. For further reference see Getting started with SQL Server database diagrams
Try DBVis - download at https://www.dbvis.com/download - there is a pro version (not needed) and a open version that should suffice.
All you have to do is to get the right JDBC - database driver for SQL Server, the tool shows tables and references orthogonal, hierarchical, in a circle ;-) etc. just by pressing one single button. I use the free version for years now.
SQLDeveloper can do this.
http://sqldeveloper.solyp.com/
For SQL statements you can try reverse snowflakes. You can join at sourceforge or the demo site at http://snowflakejoins.com/.
Why don't you just use the database diagram functionality built into SQL Server?
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