InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 01:55:39 GMT20http://www.sqlservercentral.com/Forums/Topic1367070-391-1.aspx[quote][b]Grant Fritchey (10/2/2012)[/b][hr]ERStudio from Embarcadero is my preferred tool.[/quote]Me too.Tue, 02 Oct 2012 12:49:17 GMTSteveBellhttp://www.sqlservercentral.com/Forums/Topic1367070-391-1.aspxERStudio from Embarcadero is my preferred tool.Tue, 02 Oct 2012 10:42:03 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1367070-391-1.aspx[quote][b]info 58414 (10/2/2012)[/b][hr]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 youKind regartsNicole :w00t:[/quote]Check this [url]http://msdn.microsoft.com/en-US/data/tools[/url].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 [url]http://channel9.msdn.com/events/TechEd/Europe/2012/DBI311[/url].PedroTue, 02 Oct 2012 09:39:31 GMTPiManéhttp://www.sqlservercentral.com/Forums/Topic1367070-391-1.aspxErwin , 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 upTue, 02 Oct 2012 09:26:01 GMTJayanth_Kuruphttp://www.sqlservercentral.com/Forums/Topic1367070-391-1.aspxERWin 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,RobTue, 02 Oct 2012 08:49:45 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1367070-391-1.aspxHello,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 youKind regartsNicole :w00t:Tue, 02 Oct 2012 08:19:51 GMTinfo 58414