[AccessD] SQL Server GUI tools

SeeCool Guy seecoolguy at gmail.com
Thu Oct 1 11:01:08 CDT 2020


 Hey John,

There are a number of tools suggested here:
https://www.comparitech.com/net-admin/best-database-diagram-tools/

btw, in my copy of 2017 ssms that option for diagrams has already been
removed.

more info:
https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sql-server-ver15

—
Francisco Tapia

On Sep 18, 2020 at 1:28:16 PM, David McAfee <davidmcafee at gmail.com> wrote:

> I might be wrong, but I think the diagrams are going away with SSMS 2019
>
> Also, not sure if any of you know that Access reports can be converted
> (imported) into SSRS RDLs using Visual Studio Community (free) and SSDT.
>
> I had a few reports that contained embedded sub reports which failed the
> import process.
>
> I exported those into a new Access database then saved a version of the
> main report without the embedded subreport. That new version imported fine
> and I manually embedded the subreport rdl into the main rdl.
>
> On Tue, Sep 8, 2020, 3:46 PM Stuart McLachlan <stuart at lexacorp.com.pg>
> wrote:
>
> In SQL Server Management Studio  (using 2014)
>
>
> In the  Treeview:
>
>
> Server
>
> ....Databases
>
> ......MyDatabase
>
> .........Database Diagrams
>
>
> New Diagram  (Unless you've got an aappropriate one already there)
>
> Add desired tables
>
>
> Click on the "record selector" of a field in one table and drag it over a
>
> field in another table to
>
> create a relationship.  You will be prompted for the reationsip details.
>
>
> To delete a relationship, right click on the relationship and select
>
> "Delete relationships..."
>
> You wil be prompted for confirmation.
>
>
> On 8 Sep 2020 at 21:26, John Bartow wrote:
>
>
> > Since SQL Server was recently brought up...
>
> >
>
> > Is there a decent tool to graphically layout tables and relationships
>
> > similar to how the Access relationships dialog window works?
>
> >
>
> > John B
>
> >
>
> >
>
> > --
>
> > AccessD mailing list
>
> > AccessD at databaseadvisors.com
>
> > http://databaseadvisors.com/mailman/listinfo/accessd
>
> > Website: http://www.databaseadvisors.com
>
> >
>
>
>
> --
>
> AccessD mailing list
>
> AccessD at databaseadvisors.com
>
> http://databaseadvisors.com/mailman/listinfo/accessd
>
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list