[AccessD] SQL Server GUI tools

[Stuart McLachlan]

Yep,"someone" in MS messed up big time over that one. :-)

They took it out in ver 18.0 and put it back in 18.1


On 1 Oct 2020 at 17:13, Daniel Waters wrote:

> I found this:
> 
> https://cloudblogs.microsoft.com/sqlserver/2019/06/11/sql-server-manag
> ement-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-serv
> er-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
>