Database creation/management tools?

Can someone please tell me if there are any third-party tools that will
allow me to create/manage/diagram databases as easily for SQL Server as for
Access?
I'm currently developing a pretty complex SQL database by creating it first
in Access and using the Upsizing wizard, but I've found that certain things
get lost in the translation, and I'd prefer to not have to go through the
extra work of finding/fixing the omissions.
Thanks!I would NOT develop any "pretty complex SQL database by creating it first in
Access and using the Upsizing wizard."
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Joe Sabatini" <sabatini@.optonline.net> wrote in message
news:eg2xj3GkDHA.708@.TK2MSFTNGP10.phx.gbl...
> Can someone please tell me if there are any third-party tools that will
> allow me to create/manage/diagram databases as easily for SQL Server as
for
> Access?
> I'm currently developing a pretty complex SQL database by creating it
first
> in Access and using the Upsizing wizard, but I've found that certain
things
> get lost in the translation, and I'd prefer to not have to go through the
> extra work of finding/fixing the omissions.
> Thanks!
>|||I agree with Linchi. It should be designed in a totally SQL Server aware
and compatible tool. You might want to look at the ERD tools from
Embarcadero or Sybase but they will not be cheap. Another alternative that
is less expensive but does have many features is a tool called xcase.
http://www.xcase.com/index3.html
--
Andrew J. Kelly
SQL Server MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:%232m6TjHkDHA.2200@.TK2MSFTNGP12.phx.gbl...
> I would NOT develop any "pretty complex SQL database by creating it first
in
> Access and using the Upsizing wizard."
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Joe Sabatini" <sabatini@.optonline.net> wrote in message
> news:eg2xj3GkDHA.708@.TK2MSFTNGP10.phx.gbl...
> > Can someone please tell me if there are any third-party tools that will
> > allow me to create/manage/diagram databases as easily for SQL Server as
> for
> > Access?
> >
> > I'm currently developing a pretty complex SQL database by creating it
> first
> > in Access and using the Upsizing wizard, but I've found that certain
> things
> > get lost in the translation, and I'd prefer to not have to go through
the
> > extra work of finding/fixing the omissions.
> >
> > Thanks!
> >
> >
>