[AccessD] SQL Server GUI tools

[SeeCool Guy]

 Nice!

On Oct 1, 2020 at 10:13:15 AM, Daniel Waters <df.waters at outlook.com> wrote:

> I found this:
>
>
> https://cloudblogs.microsoft.com/sqlserver/2019/06/11/sql-server-management-studio-ssms-18-1-is-now-generally-available/
>
> SSMS 18.1 does now include diagrams!
>
> Dan
>
> From: SeeCool Guy<mailto:seecoolguy at gmail.com>
> Sent: Thursday, October 1, 2020 11:03 AM
> To: Access Developers discussion and problem solving<mailto:
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] SQL Server GUI tools
>
> 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
>
>
> --
> 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
>