[AccessD] SQL Server GUI tools

[Arthur Fuller]

I have tried all the diagrammers mentioned, and concluded that a
third-party solution is best. I still use a now ancient version of
PowerDesigner, a tool dedicated solely to diagramming, but its virtue is
its independence from any specific

On Fri, Sep 18, 2020 at 4:29 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
>


-- 
Arthur