?
Solved

Tool to easily view and tweak data in a DB table... kind of like editing a spreadsheet

Posted on 2013-11-27
7
Medium Priority
?
245 Views
Last Modified: 2013-12-02
I have some small tables in a DB that would be nice to be able to tweak more or less manually... without having to write an SQL statement manually every time I want to update a single thing.

Are there any tools that load a DB table for display and I could edit individual cells easily by say, right clicking the cell, saying "change value" and then being given a box to enter the new value, and it will write and execute the sql for me?  Or something similar?
0
Comment
Question by:Xetroximyn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 39681411
SQL Server Management Studio allows you to right-click on a table, choose design. From there you can edit the columns as long as the data integrity doesn't change. For example you change varchar(10) to varchar(5) and you have existing data longer than 5. It will warn you that you are truncating some data.

http://www.microsoft.com/en-us/download/details.aspx?id=7593
0
 
LVL 43

Expert Comment

by:Chris Stanyon
ID: 39681414
0
 

Author Comment

by:Xetroximyn
ID: 39682445
Will these work with DB2?
0
Certified OpenStack Administrator Course

We just refreshed our COA course based on the Newton exam.  With 14 labs, this course goes over the different OpenStack services that are part of the certification: Dashboard, Identity Service, Image Service, Networking, Compute, Object Storage, Block Storage, and Orchestration.

 
LVL 43

Expert Comment

by:Chris Stanyon
ID: 39682458
Probably not.

You posted this in the MSSQL and MySQL Zones, so the links provided are specifically for those 2
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 39683646
have you considered MS Access and using table links... that would allow quick and dirty ability to display and change the data values....

or di you mean you want to be able to change the table structures?
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 2000 total points
ID: 39685502
I know a lot of people that use Toad for that.  It's one interface works for many different dbs.  It used to be free but know I think it may charge.  But you can still get a free trial at the very least.
0
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 39686094
I actually prefer to write update statements when doing object updates. This way I can save it so I know exactly what was changed, when, and who did it. But then I am a bit of a control freak and want to be able to easily reverse and changes.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 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