DB schema in Visio

Hi,
we have database on SQL server 2000 and want to be able
to maintain it from within Visio (version 2003 Enterprise
Architect) or at least use Visio for documentation the
database.
Has anyone some experience with maintenance db schema in visio?
I created new Database model diagram and used Reverse
Engineering to fill it with our schema. The problem is
that if DB is modified, e.g. new table/SP is added (via
sql script or SQL Enterprise Manager) and then we want to
refresh the model in Visio with Database->Model->Refresh
command, Visio does not notice the change and does not
offer to add new table/SP into model.
How I could achieve this?
Thanks
eXavierWhen you refresh you must choose whether to update the model or the database
or both... Are you sure you are selecting update model?...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"eXavier" <hurta@.email.cz> wrote in message
news:bkcf3r$3c2$1@.ns.felk.cvut.cz...
> Hi,
> we have database on SQL server 2000 and want to be able
> to maintain it from within Visio (version 2003 Enterprise
> Architect) or at least use Visio for documentation the
> database.
> Has anyone some experience with maintenance db schema in visio?
> I created new Database model diagram and used Reverse
> Engineering to fill it with our schema. The problem is
> that if DB is modified, e.g. new table/SP is added (via
> sql script or SQL Enterprise Manager) and then we want to
> refresh the model in Visio with Database->Model->Refresh
> command, Visio does not notice the change and does not
> offer to add new table/SP into model.
> How I could achieve this?
> Thanks
> eXavier
>
>|||This should work. Visio should pick up the new table if the DSN is the same
and the created table has a new table name. Not sure why it isn't working in
this case.
Please try your workflow on the Northwind database and see if it works.
Reverse-engineer NW, then add a table to NW and do a Model Refresh.
--
Keith Wilson
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OwkSXUgfDHA.2348@.TK2MSFTNGP12.phx.gbl...
> When you refresh you must choose whether to update the model or the
database
> or both... Are you sure you are selecting update model?...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "eXavier" <hurta@.email.cz> wrote in message
> news:bkcf3r$3c2$1@.ns.felk.cvut.cz...
> > Hi,
> > we have database on SQL server 2000 and want to be able
> > to maintain it from within Visio (version 2003 Enterprise
> > Architect) or at least use Visio for documentation the
> > database.
> > Has anyone some experience with maintenance db schema in visio?
> > I created new Database model diagram and used Reverse
> > Engineering to fill it with our schema. The problem is
> > that if DB is modified, e.g. new table/SP is added (via
> > sql script or SQL Enterprise Manager) and then we want to
> > refresh the model in Visio with Database->Model->Refresh
> > command, Visio does not notice the change and does not
> > offer to add new table/SP into model.
> > How I could achieve this?
> >
> > Thanks
> > eXavier
> >
> >
> >
>