June 26, 2010 at 2:06 am
I used to have a database in MySql and used MySQL Control Center from Mysql.com to easily and quickly change data that was input from customers in the tables. For example, I would correct any type-o's and fix punctuation. I could easily scan the entire table with all the data and make any changes.
I recently moved to a MS SQL 2005 database and I am looking for a similar program to quickly scan and change the customer data. I tried EMS SQL Manager for SQL Server. It allows me to do this same thing, but is too slow (like 5 minutes to make one edit).
Is there another software program that allows a non-experienced database user to make edits to the data using a spreadsheet like view?
Thanks,
RG BARBER
June 27, 2010 at 3:38 pm
You could open the table with native SQL Server Management Studio. You can than open a SQL pane to put in a select statement to bring back just the data you want to look at for editing.
June 27, 2010 at 4:58 pm
rgbarber (6/26/2010)
... to easily and quickly change data that was input from customers in the tables.
This is very bad mojo.
DBA owns the structure but not the data, user community owns the data.
Editting data on-the-fly is a call for troubles, all data changes have to be scripted, approved by business and QA; ideally executed by App team.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply