The process of managing change to systems (software and/or hardware) to mitigate risks and control when, where, what, and how changes move and who is allowed to move them.
Questions tagged [change-management]
13 questions
7
votes
3 answers
Best practices for change management with indexes
Our IT shop is first starting to build a group of DBA's. All of us (myself included) have come over from the application development/architecture world, so the DBA world is still fairly new to us.
Along with building a DBA group, we are looking to…
Chris Aldrich
- 4,916
- 5
- 34
- 55
5
votes
1 answer
Handling SQL updates for production deployments
I'm researching for quite a long time now (about two months) and haven't found a good approach for this, so I'll ask you experts out there in the hope of some enlightenment.
I run a pretty traditional LAMP web application in the cloud. The source…
denydias
- 151
- 4
5
votes
3 answers
Storing Changes To Records
Everything I am talking about relate to relational database, specific MySQL.
I have a number of tables in a database and for a moderate number of them, I am going to want to store a history of the records values when it changes. I have seen this…
ryanzec
- 505
- 1
- 7
- 14
4
votes
1 answer
What mechanisms do you use to notify third parties of future schema changes?
How do you notify third parties of future SQL Server schema changes other than through external documentation?
I've started implementing a deprecation warning extended property on objects that will be going away in the future but wanted to see if…
Michael
- 43
- 2
3
votes
2 answers
Changing the SQL Server service account - any additional considerations?
I have inherited a few instances that are running under LocalSystem. I need to change this to a domain account as we are changing our backup strategy to go to a network share and then to tape and I need to be able to assign permissions.
I know that…
SomeGuy
- 2,053
- 8
- 35
- 48
2
votes
1 answer
SELECTs in Database Change Log and Source Control
We are overhauling the way that we store our database in source control and keep a change log of it. I was reading the following article: http://thedailywtf.com/articles/Database-Changes-Done-Right, and in the Short Section of "The Taxonomy of…
Gander7
- 197
- 1
- 5
1
vote
0 answers
SQL Server Comparison
I am merging two different versions of a database. I want to add some specific fields from source database to destination, so I used Visual Studio to do that. It does the job quite well but only table level, which means it checks for the table if…
Kirk
- 111
- 4
1
vote
1 answer
Changes to main Database during Transactional Replication
Can you please advise how can I keep slave database up to date while it's in transactional replication with master.
I mean what If I change indexes, columns, tables or sthm else in master dabase? What should I do in this case?
Should I make this…
Johnny_D
- 245
- 1
- 3
- 10
1
vote
1 answer
When using a master plus multiple slaves, how do I change over from one server to a brand new one with minimal downtime?
In my particular case, I'm using Heroku Postgres (repackaged Amazon EC2 instances running PostgreSQL), but platform-agnostic answers are also good!
Heroku's instructions
describe the process for transfering over a single database (i.e. without…
Noach
- 113
- 5
1
vote
0 answers
How do I organize database initialization so it can be executed in a fixed order?
I am trying to update an established database system to leverage change management. The main point is to make the development and production environments follow the same process. I need help understanding how to group database elements into change…
Chris Betti
- 487
- 1
- 5
- 11
0
votes
2 answers
Database Change Management
What are ways in which teams handle database change management? I have a team of 8 developers making database changes concurrently.
Each developer is responsible for updating their changes in what we consider a "poor man's database change log" which…
Jordan Parmer
- 153
- 4
0
votes
2 answers
How to transfer DDL changes between different stages?
What technical solutions are available to track DDL changes and transfer them between different stages (e.g. DEV -> QA -> PROD) on postgreSQL databases? Is there a common mechanism to do that?
JanDotNet
- 101
- 2
0
votes
1 answer
How to test mysql for changes
I'm OCD person, I think I accidentally dropped something in my mysql.
Problem is I've around 50 databases, and I cannot manually check everything :(
Is there a way to check for these kind of changes? I tried to look at timestamps in /var/lib/mysql…
user21227