Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [upgrade]

Upgrade refers to the replacement of a product with a newer version of the same product.

  • replace (a software program) with a more recently released, enhanced version.
  • replace (a hardware device) with one that provides better performance.

Upgrade refers to the replacement of a product with a newer version of the same product.

  • replace (a software program) with a more recently released, enhanced version.
  • replace (a hardware device) with one that provides better performance.

Benefits

Generally meaning a replacement of hardware, software or firmware with a newer or better version, in order to bring the system up to date or to improve its characteristic and performance

Risks

Upgrades of hardware involve a risk that new hardware will not be compatible with other pieces of hardware in a system or drivers, conversely, there is the same risk of non-compatibility when software is upgraded for previously functioning hardware to no longer function.

Upgrades of software introduce the risk of bugs and incompatibility with other software that communicates with it.

513 questions
81
votes
5 answers

Are SQL Server in-place upgrades as ill advised as they used to be?

I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade. I'm currently upgrading my 2008 R2 DEV and TEST systems to SQL Server 2012 and need to use the same…
DamagedGoods
  • 2,591
  • 6
  • 34
  • 48
29
votes
1 answer

What are Objective Reasons to Prefer SQL Server 2016 over Earlier Versions?

As Microsoft makes SQL Server version upgrades more frequently since the SQL Server 2005 or 2008 days, a lot of companies find it difficult to determine when an upgrade is a "must have!" and when an upgrade is a "nice to have" In the spirit of a few…
Mike Walsh
  • 18,278
  • 6
  • 50
  • 74
22
votes
3 answers

SQL Server Distributed Availability Group databases not syncing after a server reboot

We're getting ready to perform a large upgrade on our SQL Servers and are noticing some unusual behavior with Distributed Availability Groups that I'm trying to resolve before moving forward. Last month, I upgraded a remote secondary server from…
Taryn
  • 9,746
  • 4
  • 48
  • 74
18
votes
3 answers

How to upgrade PostgreSQL from version 8.4 to 9.4?

I want to upgrade my PostgreSQL from version 8.4 to 9.4. The documentation is not very clear to me. Will I lose my old databases if I do the upgrade? How can I backup my old databases if I am to lose them after the upgrade? How can I upgrade my…
Ghasem
  • 549
  • 1
  • 5
  • 12
17
votes
2 answers

pg_upgrade unrecognized configuration parameter "unix_socket_directory"

I'm trying to upgrade Postgresql from 9.2 to 9.3 in Fedora 18 using this command as the postgres user $ pg_upgrade -b /bin -B /usr/pgsql-9.3/bin -d /var/lib/pgsql/data -D /var/lib/pgsql/9.3/data/ -j 2 -u postgres The error in the log command:…
Clodoaldo
  • 1,145
  • 2
  • 8
  • 22
16
votes
3 answers

Eliminating OIDs while upgrading PostgreSQL from 9.4 to 12

I'm currently running PostgreSQL 9.4 in my production environment, but we're in the process of doing an OS upgrade on the server so I thought it might be time to upgrade our PostgreSQL version to the latest (12) so that I could potentially make use…
G_Hosa_Phat
  • 445
  • 2
  • 5
  • 16
14
votes
3 answers

How to do a minor upgrade of PostgreSQL on Windows, e.g. 9.3.0 to 9.3.1?

What is the recommended way to perform a minor upgrade from PostgreSQL e.g. 9.3.0 to 9.3.1 using the Enterprise DB built windows installer? Should I uninstall first or just install over the existing installation? The current installation was…
buzz3791
  • 396
  • 1
  • 2
  • 13
14
votes
4 answers

MySQL - mysql_upgrade - Error occurred: Cannot setup server variables

I run MySQL 5.7.11 inside the official docker image. When I want to upgrade I get the following error: mysql_upgrade -uroot -p password: Error occurred: Cannot setup server variables. I searched around, didn't find any hint. I tried to run with…
Pierre Ozoux
  • 441
  • 1
  • 3
  • 8
14
votes
1 answer

Can I tell when and who updated my database from v11 to v12 on Azure?

Earlier today I noticed that all my Azure SQL database servers where updated from v11 to v12. I am the only one in my company that should be touching those dials, but not the only person in my company with the access. Since I did not initiate this…
Erik
  • 4,833
  • 4
  • 28
  • 57
13
votes
1 answer

SQL Server AlwaysOn database stuck in Not Synchronizing / In Recovery mode after upgrading. Error: Cannot open database '...' version 782

While testing an upgrade from SQL Server 2014 SP1 (12.0.4422.0) to SQL Server 2016 CTP 3.2 (13.0.900.73) I was following the recommended update process and ran into an issue where the database would not start on the old primary after failing over to…
Greg Bray
  • 1,053
  • 3
  • 13
  • 20
12
votes
2 answers

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER statements for every table and column that needs to…
Stephen Ostermiller
  • 423
  • 1
  • 3
  • 10
11
votes
4 answers

SQL Server 2019 performance worse than 2012... am I missing something?

We have a SQL Server 2012 server which far outperforms a SQL Server 2019 database on (as far as I can see) the same infrastructure. We are hosting both databases on a cloud platform with the same SLAs. Both have 180GB RAM and 16 processors. However…
blobbles
  • 1,621
  • 1
  • 12
  • 19
11
votes
1 answer

SQLServer Upgrade Advisor 2014 hanging

I try to run SQL Server Upgrade Advisor 2014 against a SQL Server 2008 server. Everything looks fine when connecting to the 2008 server and I can select which database I would like to analyze. But once launched, it runs forever, without doing…
irimias
  • 1,921
  • 2
  • 14
  • 27
10
votes
2 answers

Read ancient Oracle database into current Oracle version

An old computer with Oracle 8i is dead. We have the daily backup of the database (C:\oradata). We are unable to install this old Oracle version anywhere because we don't have the install CDs for it. Can we read this database with, for example,…
Gregory MOUSSAT
  • 203
  • 1
  • 4
9
votes
1 answer

AlwaysOn Availability Group error after Windows Update in environment without a failover cluster

Our SQL Server service was down this morning which brought down some of our websites. When I went to check the Windows Event Viewer I saw the following errors: Script level upgrade for database 'master' failed because upgrade step …
skeletank
  • 301
  • 2
  • 9
1
2 3
…
34 35