Sparx Enterprise Architect for SQL Server modeling?

Posted by Tone on Stack Overflow See other posts from Stack Overflow or by Tone
Published on 2010-05-17T22:53:42Z Indexed on 2010/05/18 2:51 UTC
Read the original article Hit count: 337

Filed under:

enterprise-architect

|

sql-server

I have used MS SQL Server Management Studio for most of my database modeling to this point in my career. I am a database developer (not a DBA), but interested in the benefits with using Sparx systems Enterprise Architect for data modeling. I do not have the need to generate scripts for different databases, other than that what does using Sparx EA buy me that SQL Management Studio does not?

© Stack Overflow or respective owner

Related posts about enterprise-architect

Séminaires techniques : La modélisation UML avec Enterprise Architect, par Objet Direct, en avril à

as seen on Developper.com - Search for 'Developper.com'
Séminaires techniques : La modélisation UML avec Enterprise Architect, par Objet Direct Le 7 avril à Lyon, le 8 avril à Grenoble, le 14 avril à Paris (9h-11h) Avec les retours d'expérience projets menés par Objet Direct chez EDF, PSA, au Conseil d'Etat et au CHU de Grenoble Pour des modèles… >>> More
A free Step by Step guide to learning Sparx Enterprise Architect

as seen on Stack Overflow - Search for 'Stack Overflow'
I have just downloaded Sparx Enterprise Architect 7.5 but unfortunately I am not able to find a getting started guide or something like that. I have gone through official site of Sparx but there is not step by step guide to learning Sparx EA. I want a guide that will implement a small project and… >>> More
Sparx System Enterprise Architect Book

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know if there is a book about Sparx systems Enterprise Architect ? (besides sparx site and reference) >>> More
Copy diagram with swimlanes in Enterprise Architect

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
This is a post mostly to myself, so that when I forget this I can come here and check it out :) (I forget about ctrl-b from time to time) When copying diagrams from Enterprise Architect you can use ctrl-B to include the swim-lanes. A normal ctrl-c will not give you the swim-lanes. A side effect… >>> More
What is a good Visio Enterprise Architect replacement?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been using Visio 2002/2003 Enterprise Architect to do my database schema design visually and then forward-generate the DDL to create the database. I wanted to switch to Visio 2007, but while it does have database diagramming support, it doesn't have the ability to generate DDL. Bummer. I am… >>> More

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More