Does anyone have any ideas ..

.. on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.
I'd like to put together a list (map) of every table referenced on
each php page, as well as one showing every php page which uses each
table.
I'd like to have this as a reference so that when we bring in a
programmer, they can work more efficiently and be less likely to
create bugs.
Any ideas?
-MoDo you mean an ERD? How about using the diagram tool built into SQL Server.
If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Mo" <Mehile.Orloff@.gmail.com> wrote in message
news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
> .. on making a DB map?
> Hopefully someone knows of a tool/util.
> Here's where I'm coming from:
> We have a list of changes to make to our DB and the PHP interface.
> I'd like to put together a list (map) of every table referenced on
> each php page, as well as one showing every php page which uses each
> table.
> I'd like to have this as a reference so that when we bring in a
> programmer, they can work more efficiently and be less likely to
> create bugs.
> Any ideas?
> -Mo|||On Mar 3, 5:33=A0pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Do you mean an ERD? =A0How about using the diagram tool built into SQL Ser=ver.
> If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSM=S.
> --
> Andrew J. Kelly =A0 =A0SQL MVP
> Solid Quality Mentors
> "Mo" <Mehile.Orl...@.gmail.com> wrote in message
> news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
>
> > .. on making a DB map?
> > Hopefully someone knows of a tool/util.
> > Here's where I'm coming from:
> > We have a list of changes to make to our DB and the PHP interface.
> > I'd like to put together a list (map) of every table referenced on
> > each php page, as well as one showing every php page which uses each
> > table.
> > I'd like to have this as a reference so that when we bring in a
> > programmer, they can work more efficiently and be less likely to
> > create bugs.
> > Any ideas?
> > -Mo- Hide quoted text -
> - Show quoted text -
Thanks for the suggestions.
I'll start there.
-Mo