Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data-Modeler-Tool Expand / Collapse
Author
Message
Posted Tuesday, October 2, 2012 8:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 7, 2014 8:05 AM
Points: 53, Visits: 179
Hello,
can anyone give a recommendation for a data modeling tool that ER data modeling. allowed with SQL Server, and change scripts generated (Compare and Synchronize with other databases) Ideal even integration in Visual Studio (C # code or VB.net code) would be generated.
Thank you
Kind regarts
Nicole
Post #1367070
Posted Tuesday, October 2, 2012 8:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:28 AM
Points: 1,197, Visits: 1,241
ERWin is one tool that can be used for modeling, reverse enigineer schema, forward engineer schema (make change scripts). It doesn't integrate into VS (that I'm aware of). It has it's own quirks in the interface and is kinda pricey, but once you get past that I've been happy with it.

HTH,
Rob
Post #1367091
Posted Tuesday, October 2, 2012 9:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,786, Visits: 1,014
Erwin , embacardo and visio are some of the most common tools out there , Visio doesnt support the full stack some versions wont allow deployment to script the actual objects.

If your using OODBD then EF and entity data model is available in visual studio , i dont think its supported in the latest version but you can look it up


Jayanth Kurup
Post #1367117
Posted Tuesday, October 2, 2012 9:39 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 2:30 PM
Points: 515, Visits: 1,138
info 58414 (10/2/2012)
Hello,
can anyone give a recommendation for a data modeling tool that ER data modeling. allowed with SQL Server, and change scripts generated (Compare and Synchronize with other databases) Ideal even integration in Visual Studio (C # code or VB.net code) would be generated.
Thank you
Kind regarts
Nicole

Check this http://msdn.microsoft.com/en-US/data/tools.
It integrates with VS and allows checkins, checkouts, generate scripts for changeset X to Y, generate differential script from reference database to modeling database, etc...
It allows both schema comparison and data...
This video from chanel9 demonstrates it http://channel9.msdn.com/events/TechEd/Europe/2012/DBI311.

Pedro




If you need to work better, try working less...
Post #1367130
Posted Tuesday, October 2, 2012 10:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 6:53 AM
Points: 13,890, Visits: 28,285
ERStudio from Embarcadero is my preferred tool.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1367167
Posted Tuesday, October 2, 2012 12:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 25, 2013 5:59 AM
Points: 184, Visits: 1,537
Grant Fritchey (10/2/2012)
ERStudio from Embarcadero is my preferred tool.


Me too.
Post #1367240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse