I am looking for a cheap and highly efficient data modeling tool for my SQL server 2008 r2 and 2012 environment. my employer's infr contains postgres, oracle and SQL server. I need a tool which can create data diagrams of the existing DB, and other data modeling tasks,
Does any one has any advice.
The best data modeling tool (regardless of platform) in my opinion is Embarcadero's ERStudio. CA's ERWin is another that is used by quite a few out there.
There truly is NO cheap option for this, especially since you need cross-platform. Take Oracle and postgres out and ERStudio is VERY affordable for just a SQL Server license.
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service