October 2, 2012 at 8:19 am
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:
October 2, 2012 at 8:49 am
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
October 2, 2012 at 9:26 am
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
October 2, 2012 at 9:39 am
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
:w00t:
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
October 2, 2012 at 10:42 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2012 at 12:49 pm
Grant Fritchey (10/2/2012)
ERStudio from Embarcadero is my preferred tool.
Me too.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply