Data-Modeler-Tool

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Data-Modeler-Tool

Data-Modeler-Tool

Rate Topic

Display Mode

Topic Options

Author

Message

info 58414

Posted Tuesday, October 02, 2012 8:19 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:27 AM
Points: 23, Visits: 93

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
w00t

Post #1367070

robert.gerald.taylor

Posted Tuesday, October 02, 2012 8:49 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:31 AM
Points: 733, Visits: 781

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

Jayanth_Kurup

Posted Tuesday, October 02, 2012 9:26 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008

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

PiMané

Posted Tuesday, October 02, 2012 9:39 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:02 AM
Points: 403, Visits: 904

info 58414 (10/2/2012)

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

Grant Fritchey

Posted Tuesday, October 02, 2012 10:42 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 13,371, Visits: 25,144

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1367167

SteveBell

Posted Tuesday, October 02, 2012 12:49 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 5:59 AM
Points: 209, Visits: 1,537

Grant Fritchey (10/2/2012)

ERStudio from Embarcadero is my preferred tool.

Me too.

Post #1367240

« Prev Topic | Next Topic »

Permissions