visual studio 2005 database modeller?

[Andrew Clancy]

hi,

does visual studio 2005 have a database modeller, with reverse engineering
and generating, like visio & vs2k3 enterprise architect?

if so, anyone got any resources on how to find/use it?

cheers,
andy

ps. anyone know anything about it's ORM features/ how it compares to
LLBLGen? that's me next question

 

[Mark Nelson [MS]]

Yes, Visual Studio 2005 includes Visio and the database modelling add-on
just like Visual Studio 2003. The big difference is that the core Visio app
has been upgraded from version 2002 to version 2003. This means that VS2005
with Visio can read and write files created by Microsoft Office Visio 2003.

I'm not sure what the VS2005 product SKU'a are but there should be one
similar to the Enterprise Architect edition again.

 

[Andrew Clancy]

What, so let me get this straight ... you've got a UML modeller within
Visual Studio 2005, but you still get a copy of Visio for database modelling
that's a separate app still (not built in)?

I assume you'd need the Enterprise License for Visio Enterprise (database
generation, round-trip UML etc) still?

Cheers,
AC

 

[Al Edlund]

well kinda. Visio Enterprise Architect edition comes with Visual Studio.Net,
and the latest version (the v2005 EA which is still in beta) is based on
v2003. It (just like it's predecessors) is a fully functional version of Pro
with the software and database modeling addons included. Round trip UML
might be considered to be a stretch.
al

 

[clintonG]

<snip />

It should be noted that the 'enterprise tools' that were available with
Visual Studio .NET 2003 Enterprise Architect are only currently available to
those who want to use the Team System. That means the use of Windows Server
2003 and Active Directory are required. There is no way to even get Visual
Studio Professional Edition without Team System. The whole beta has been
bundled and comingled to push customers into Team System.

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

 

[Al Edlund]

as an observer from the side, VS2005 with team support is available but at
least in my case did not require that the team server be available and
installed. I would suspect that when the product hits in November they may
not be merged because of the needs of those that are not in a team
environment. Remembering this is beta and all bets are off.

al

 

[Andrew Clancy]

Ok, understood about the team stuff guys - but does anyone know of any sites
or documentation that have information about where to find the database
modelling in VS2005, ie. 'Reverse Engineer (database)' and 'Generate
Database'. This is essential for an architect, along with UML and the same
round trip engineering for .Net projects.

 

[Al Edlund]

It's not in vs2005, it's in visio enterprise architect which is a separate
directory on the install cd and is installed as it's own product. The
documentation is in the help file for the product.
al