October 8, 2003 at 8:53 am
Is it better to install EM on developers desktops or just install QA? Are there benefits (security, etc.) by only providing QA? Or is it better to allow them to have EM?
October 8, 2003 at 9:27 am
quote:
Is it better to install EM on developers desktops or just install QA? Are there benefits (security, etc.) by only providing QA? Or is it better to allow them to have EM?
well, I would say that there is not really a difference. AFAIK almost everything that can be done in EM can also be done via QA. In fact, EM is a GUI for the underlying T-SQL commands.
Not sure if there could be a licensing issue?
But it shouldn't matter at all because the developer should only develop against a dedicated development box and not against a production box. And if the development box crashes and needs to be reinstalled you can easily put a new image on it.
Frank
Edited by - Frank Kalis on 10/08/2003 09:28:49 AM
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 8, 2003 at 9:29 am
It depends on what you allow the developers to do. Here, the developers have EM for they do their own DB development with help for the DBA's. Before the app goes to production, the DB is reviewed by the DBA's so that it meets the DB Standards and the performance is sound. The DBA's then move the DB to production where the developers only have the rights to select on the tables and execute the stored procedures. Now, if the developers only had the rights to query the tables and views and execute the stored procedures, then I would say they only need the QA.
Dave
October 8, 2003 at 10:31 am
if you want to allow your developers to setup DTS packages and SQL Manager scheduled task etc then they will need access to EM.
Think this depends on the size of your team really, the larger the team, the less access you should give to certain people (You will have different people to take care of different things), and so QA is better for restricting access.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply