Guidance/process for updating or changes data in production.

15 pts.
Tags:
Change management
Data production
Hi folks, I am looking for some best practices in change management which can implemented to perform the changes to the data in production. May be code changes to changes to actual data. I appreciate if you can share some process, guidelines or any thoughts on this. Regard, RM

Software/Hardware used:
sql

Answer Wiki

Thanks. We'll let you know when a new response is added.

Thanks for coming to ITKE.

It is difficult to just give you a specific answer to this are there are variables to consider. Also, do you have any documentation/standards in place today?

Here is a link to a web site that will step you through a tutorial on change management.

http://www.change-management.com/tutorial-change-process-detailed.htm

As you get furthur along in the process. please come back and ask more specific questions.

 

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RMysari
    Thanks for your reply.We dont have any policy inplace as such in place now. I am looking specific to the changes to the production DB. How a change is performed to the prod DB using the change management best practices ??
    15 pointsBadges:
    report
  • TomLiotta
    There are at least three different kinds of "changes" that can apply to a database. Different types of databases might handle the three types of changes in very different ways.   We need to know what DBMS is involved, and what kind of "change" you're asking about. The DBMS might be Microsoft's SQL SERVER, or IBM's DB2, or Oracle, or any of a number of others. The version of the DBMS and the platform that it's installed on would be helpful.   The "change" might be to data records stored in the database. Or it might be to the structure of the database, e.g., adding new tables, changing column data types or changing referential constraints. Or it might be changing ownership or authority attributes.   Other ITKE members might have additional ways of looking at your question.   But the question needs to be better described. We don't know how to answer without creating a whole course in database and database management concepts.   Tom
    125,585 pointsBadges:
    report
  • carlosdl
    Yes, much more details are needed.  In Oracle, for example, there's a feature called Edition-Based Redefinition, which could be helpful, but without knowing what you want to do, the systems involved, the policies in place, etc,  there's not much we can suggest.
    70,200 pointsBadges:
    report
  • philpl1jb
    Various change management systems can be purchased to manage program and perhaps data structure changes.   A testing and approval process should be documented and enforced with documentation on every move.   Different people at different levels should test and approve all moves.   Methods for emergency changes should be documented.   Phil
    50,860 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following