[AccessD] SQL Server GUI tools

[Stuart McLachlan]

Be aware that SSMS ver18.1 to 18.5 Database Diagrams apparently were buggy.

https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-2017#ssms-
180-preview---cumulative-changelog-through-preview-6

 Currently says:

SSMS 18.6 is the latest general availability (GA) release of SSMS.
...
Fixed long outstanding issue with Database Diagrams, causing both the corruption of existing 
diagrams and SSMS to crash. If you created or saved a diagram using SSMS 18.0 through 
18.5.1, and that diagram includes a Text Annotation, you won't be able to open that diagram 
in any version of SSMS. With this fix, SSMS 18.6 can open and save a diagram created by 
SSMS 17.9.1 and prior. SSMS 17.9.1 and previous releases can also open the diagram after 
being saved by SSMS 18.6.

(Note that the content of the URL above is liable to change at any time as they release 
updates.)
 

On 2 Oct 2020 at 7:26, Stuart McLachlan wrote:

> 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-man
> > ag 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-se
> > rv 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
> > 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>