Questions tagged [change-management]
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.
13
questions
0
votes
2
answers
176
views
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?
- 101
1
vote
0
answers
43
views
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 ...
- 447
0
votes
1
answer
1k
views
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?...
user21227
0
votes
2
answers
682
views
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 ...
- 153
2
votes
1
answer
41
views
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, ...
- 197
5
votes
1
answer
1k
views
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 ...
- 51
1
vote
0
answers
59
views
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 ...
- 111
3
votes
2
answers
5k
views
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 ...
- 1,973
1
vote
1
answer
82
views
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? ...
- 245
1
vote
1
answer
998
views
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 ...
- 113
4
votes
1
answer
227
views
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 ...
- 43
5
votes
3
answers
4k
views
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 ...
- 495
7
votes
3
answers
1k
views
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.
...
- 4,896