Solved

What tool you use to manage MS SQL Server 2005/2008?

Posted on 2011-09-29
8
185 Views
Last Modified: 2012-05-12
Hi experts!

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.
0
Comment
Question by:dvplayltd
8 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 167 total points
ID: 36890095
SQL Management Studio serves me very well for managing SQL Server; however, it sounds like you are looking for more of a development tool. Visual Studio may be more of what you are looking for. Have you used any of the Database project templates within Visual Studio?
0
 
LVL 15

Assisted Solution

by:faiga16
faiga16 earned 167 total points
ID: 36892804
Use teh Visual Studio Databse Edition 2010 (this should be part of the MSDN Visual Studio Premium Edition). It will give you all the things you wanted plus more!
0
 

Author Comment

by:dvplayltd
ID: 36893085
To faiga16

As I look the point you earn here, you should be know what you are talking about. Fine, I'm ready to give you point, just a question - currently I have MS VS 2008 Team System Architect edition.  Do I have it in this version of studio? What are name of tool in it?

other is -  Visual Studio Databse Edition 2010 does it work with SQL Server 2005 ? Or I should go to SQL 2008 ?

(With sure I'l install it to test, but this is long process, that is why I ask here)
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:dvplayltd
ID: 36893132
Well, I have Database project, but look that I do not have Wizard template to import database. WHat I need to d this ?
0
 

Author Comment

by:dvplayltd
ID: 36893232
Hyyym. I review this Database editon. Look to have interesting think, but not like is my primary need. My primary need is to group on 1 place for example 10 tables, 10 views and 10 SP and to have all options (edit, view data in table, run view) and other without need to navigate all the time to my obejct.

It has such future or not? If has, what is his name ?

(In any case I'l lgive you point, but please write some words to speed up my research)
0
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 166 total points
ID: 36895494
There are some 3 party tool from Redgate and Altova.
0
 

Author Comment

by:dvplayltd
ID: 36895706
To PatelAlpesh

Well, i'm sure there 100+ solution on market. My question is try to save my tme before start reaserching it. Does Redgate have futures like i describe? it is vital to me (and anyone which do job like this). When I start programing a some sub function of software I work in this way and it is really very time consuming all the time to navigate between tree of tables, views, and SP.
0
 

Author Closing Comment

by:dvplayltd
ID: 36908103
10x and thank for your time.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question