Information générale
Catégorie:
Produits tierce partie
>We need an easy-to-use tool that would allow one or two of our junior developers to query, and only query, a SQL Server database.
>
>We have Entreprise Manager on other desktops but our DBA's fear it is too powerful a tool for our junior developers (and have not intention of spending any time setting up permissions).
>
>Several tables contain about 5-20 GB if that's of any help.
>
>Any suggestions?
>
>TIA,
>Daniel
There is a tool called exactly the same as your title, namely, SQL Server Query. It is just a tool that comes with SQL Server that allows you to run any SQL statement.
Now, security is still an issue, so be sure the DBA sets proper permissions. Alternatively, if they are running Win 2K or above as their workstation, you can create a local SQL Server, have it run on their personal workstation and create a database and restore data from production. Then, you can let them do whatever they want, since the data with be real, but not be production. And whenever, they screw it up, just restore the database as needed.
HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement