What tool you use to manage MS SQL Server 2005/2008?
Posted on 2011-09-29
I’m a professional database programmer based on MS technology and I use SQL Server 2005 and from soon 2008. Although I use Microsft Management studio I’m not happy with it at all .. but I use it extensive – both to make design of database and to extract / change data in tables. And after I start review neq management tool from SQl Server 2008 R2 I’m really disappointed … no useful new futures, but some old and fine working are changed in negative direction …
So my question is – what is your favoiurte tool for manipulate the SQL Server database? Especially I need to have follow function: from database diagram to be able to add not only tables, but Views and Stored Procedures. The question is that I have a 100 tables and 200 SP in a database, but when I program a part of my software I want to group somewhere 10 tables, 20 SP and 10 views which are logical connected each other. In this way I’ll lose much more smaller time then to navigate all the time between them.
Other which make me nervous in MS Management tool is that I can’t reach data in tables from diagrams. Look very hard to MS programmer to add a menu here – Edit record …
Please recommend me you best tool for SQL Server managment.