I use Visio, the Crows Foot Database Notation stencil isn't bad (considering
it's kinda free)
Nick Fordham
Business Analyst
Bairnsdale Regional Health Service
Ph: 5150 3490
Mobile: 0409 553 465
www.brhs.com.au
Think Green, read it from the screen.
Bairnsdale Regional Health Service acknowledges the Gunaikurnai people as the
traditional owners of the land on which the health service is located.
We recognise and respect their cultural heritage, beliefs and relationship with
the lands. We pay our respects to elders both past and present and thank them
for their contribution to the health service.
This communication is intended only to be read or used by the addressee.
Information contained in this communication may be confidential information. If
you are not the intended recipient, any use, interference with, distribution,
disclosure or copying of this material is unauthorised and prohibited. The
confidentiality attached to this communication is not waived or lost by reason
of the mistaken delivery to you. If you have received this communication in
error, please destroy it and send a reply message to the author.
From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On ;
Behalf Of DAVEY, Peter
Sent: Wednesday, 7 September 2016 4:56 PM
To: 'chai-t@xxxxxxxxxxxxx'
Subject: [chai-t] Re: Data Modelling Tool
Ben,
Have you had a look at Visio? With the pro version you can connect to a DB
and create an ER diagram which is great for documentation. You can also create
ER diagrams from scratch - you use dialogue boxes to enter details about table,
columns relationships etc.. A long time ago I had a version that would
generate the scripts to create the DB but unfortunately that feature's no
longer available however this
blog<http://www.jamesserra.com/archive/2011/12/export-sql-server-scripts-with-visio-2010/>
has some info about an add-in that you can use that sounds like it will do the
trick. Let us know how you go.
Cheers
Peter Davey | Analyst
Business Intelligence Unit | Austin Health
PO Box 5555 Heidelberg Vic 3084
ph. +61 3 9496 3768
email. peter.davey@xxxxxxxxxxxxx<mailto:peter.davey@xxxxxxxxxxxxx> |
www.austin.org.au<http://www.austin.org.au/>
From: chai-t-bounce@xxxxxxxxxxxxx<mailto:chai-t-bounce@xxxxxxxxxxxxx>
[mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of OASTLER Ben
Sent: Wednesday, 07 September 2016 4:05
To: chai-t@xxxxxxxxxxxxx<mailto:chai-t@xxxxxxxxxxxxx>
Subject: [chai-t] Data Modelling Tool
Hi everyone,
Is anyone using a data modelling tools like ERWin? We received a quote from
them for $14,000 for a concurrent user licence or $7,000 per named user. I'm
looking for something a little cheaper.... actually a lot cheaper.
Thanks
Ben
Ben Oastler | Data Analytics Specialist - Business Intelligence Services
St Vincent's Melbourne | PO Box 2900 | 41 Victoria Parade, Fitzroy VIC 3065
t: +61 3 9231 2506 | www.svha.org.au<http://www.svha.org.au/>
[cid:image002.jpg@01CE2B97.03F7F180]
P Please consider the environment before printing this email
______________________________________________________________________
This email and any attachments to it (the "Email") is confidential and is for
the use only of the intended recipient, and may not be duplicated or used by
any other party without the express consent of the sender. If you are not the
intended recipient of the Email, please notify the sender immediately by return
email, delete the Email, and do not copy, print, retransmit, store or act in
reliance on the Email. St Vincent's Health Australia ("SVHA") does not
guarantee that the Email is free from errors, viruses or interference. Emails
to and from SVHA or its related entities may be scanned and filtered in
locations outside Australia.
______________________________________________________________________
This email contains confidential information intended
only for the person named above and may be subject to
legal privilege and confidentiality obligations imposed
by legislation or be subject to intellectual property
protection or copyright. If you are not the intended recipient,
any use, disclosure, copying or distribution of this transmission
is prohibited. If you have received this message in error,
please notify us immediately by return email and delete the
original email and any attachments.
Austin Health provides no guarantee that this transmission
is free of virus or that it has not been intercepted or altered.
______________________________________________________________________