Member Avatar for Big Mountain

I have a need for a program better than Query Analyzer, I use Enterprise Manager on a daily basis for work purposes and have given the Query Analyzer program to our head person in charge of the front-end of the software, but they are now having a growing need to edit bulk things and with a SELECT statement in Query Analyzer you then have to go back and do update statements to update specific fields. With Enterprise Manager you can click in the box and change the values on the fly. Now as much as this scares me I dont want to give them Enterprise Manager just because of its sheer power, but I want them to have a similar program to be able to edit the fields right in front of them (easier) and just have to write a select statement..

Any suggestions

  • 3 Contributors
  • 2 Replies
  • 125 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for pritaeas

Try TOAD, it's free (toadsoft.com). Navicat is my tool of choice, but this one is commercial (navicat.com).

Member Avatar for mwasif

You can also use HeidiSQL and it is free.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.