New answers tagged upgrade
1
vote
Desired State Schema Best Practices for continous schema + data upgrades at different on prem locations
It sounds like you're re-inventing a state-based deployment tool. I would choose a tool (Microsoft SSDT, RedGate SQL Change Automation) and then get that to work for your project instead.
Both offer ...
1
vote
What is the best way to migrate & upgrade a extremely large postgreSQL server to another hardware whilst minimising downtime
Do not upgrade to any version below v14.
You can use streaming replication and switch-over to move the database to a different machine. Upgrade with pg_upgrade -k requires very little down time. ...
Top 50 recent answers are included
Related Tags
upgrade × 459sql-server × 135
mysql × 92
postgresql × 87
sql-server-2016 × 34
oracle × 33
sql-server-2008-r2 × 28
sql-server-2012 × 26
mysql-5.6 × 26
sql-server-2014 × 25
mongodb × 24
sql-server-2008 × 22
mysql-5.5 × 21
replication × 18
migration × 18
ubuntu × 16
sql-server-2017 × 15
mariadb × 14
service-pack × 14
oracle-11g-r2 × 13
mysql-5.7 × 13
sql-server-2005 × 12
windows × 12
installation × 12
performance × 11