[AccessD] SQL Server GUI tools

[Arthur Fuller]

Con

On Fri, Sep 18, 2020 at 7:41 PM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> 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
>
>

-- 
Arthur