Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit 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.

1
vote
1answer
16 views

Azure SQL Database patch and update doubts

It is known that Microsoft automates the patch and update of Azure SQL Database. But, some times applications must be tested before being applied any type of patch or update, because there's a ...
0
votes
0answers
13 views

After upgrading from PG 9.3 to 10 indices became corrupted

So recently I was upgrading the database in production from Postgres 9.3 to 10. In addition to upgrade, we wanted to move the database to another machine. I know, doing it "in place" would be easier ...
1
vote
1answer
19 views

AWS RDS (PostgreSQL) - Master user lost all privileges after upgrading from v9.6 to v10.6-R1

I just upgraded my AWS RDS DB instance from Postgresql v9.6 to v10.6-R1. I did this manually using the "Modify" tab in the Databases section under the Dashboard. Immediately afterwards, as the master ...
0
votes
1answer
29 views

Wrong InnoDB table status (Size/Rows) after updating from MySQL 5.7 to 8

I've upgraded from Mysql 5.7 to 8 on Ubuntu 18.04 Made it by guide, very accurate, on a new empty server, checked all error/warning logs and fixed it. Everything works just fine with it. I have 2 ...
0
votes
1answer
30 views

Upgrading PostgreSQL 9.3 to 9.5

I want to upgrade version 9.3 to 9.5 but after some steps I find that I upgraded to version 10, but I'm looking to go from 9.3 to 9.5. When I type the pg_lsclusters command I find myself with three: ...
0
votes
3answers
31 views

Debian Wheezy to Jessie — MySQL Dead Slow

We just upgraded the Debian Wheezy(7) to Jessie(8). All upgrades went smooth except MySQL which I think is causing some or exhaustive slowness specially in the MySQL's information Schema. the more ...
5
votes
1answer
118 views

Can we download SSRS 2017 to use with SQL Server 2016?

We are using our organization's SQL Server 2014 SP3 servers. (They also have 2016 SQL Servers, but we elected to skip 2016 and just move to the next SQL servers when they get installed.) We have a ...
2
votes
1answer
67 views

Non-CDB database vs Single tenant CDB

I am looking at the prospect of upgrading from oracle 11G to 12C, and I am looking at the cdb vs non-cdb models, and I am having a hard time seeing the benefit of using CDB, without multitenant ...
0
votes
1answer
47 views

MySQL 5.7 to MariaDB 10.3.13 configuration overwritten - correct way

I have earlier MySQL 5.7 over Ubuntu 16.04 with following configuration in /etc/mysql/my.cnf. [mysqld] innodb_buffer_pool_size = 1228M innodb_log_file_size = 512M innodb_log_buffer_size = 16M ...
0
votes
1answer
57 views

Changing compatibility level from 2008 to 2016

I have a database with hundreds of stored procedure, views, triggers, function, ... The database Compatibility Level is 2008 (100) and we would like to move it to 2016 (130). The SQL Server version ...
0
votes
1answer
55 views

Restore job run successfully without error but actually not applied during log ship from older version to newer one

Our requirement is for SQL Server 2008 R2 databases to be upgraded/migrated to SQL Server 2016. We want to configure log shipping between SQL Server 2008 R2 (source) and SQL Server 2016 (target). We ...
0
votes
3answers
92 views

Deprecated raiserror detection

I want to upgrade SQL server from 2008 to 2014 versiyon. I checked all of the deprecated features including raiserror syntax. But I have many stored procedures to check. Some of them use new syntax, ...
0
votes
0answers
71 views

postgresql 11 & windows server 2008

I plan to upgrade a PostgreSQL/PostGIS server from 9.6 to 11. The server is running on windows server 2008 R2 64. According to the doc, PostgreSQL 11 and Windows Server 2008 has not be tested. So ...
0
votes
1answer
14 views

Upgrade/Transition Path from MySQL Community 5.6.31 to Enterprise

Full disclosure. I have never upgraded a database. I have a MySQL Community that is not the latest @5.6.31 ( latest is 8 ?) to the paid, Enterprise version. We will ask Tech Support once purchase of ...
1
vote
0answers
238 views

mysql 8 is failure to start after upgrade from 5.7

I've upgraded one of the slave server from mysql 5.6 to 5.7 and now 5.7 to 8. But after up-gradation steps done when i use systemctl start mysqld.service or systemctl restart mysqld facing error and ...
1
vote
1answer
728 views

Downgrading PostgreSQL 10 to 9.4

Are there any particular precautions I should take when downgrading PG 10 to 9.4? I have a database on Heroku (PG 9.4) which I'm going to upgrade to PG 10.6. In case something goes wrong, I want to ...
1
vote
0answers
30 views

SQL Server upgrade re-initializes subscriptions

I recently, in a test environment, upgraded my SQL Server Distributor from 2012 to 2017. The upgrade went off without a hitch but I noticed that after the upgrade was completed all of my subscriptions ...
1
vote
1answer
76 views

Could anyone please help me understand MSSQL Compatibility Level?

I have a task to upgrade a database from SQL Server 2005 to SQL Server 2012. So I took backup of the old database and simply restored it onto SQL Server 2012 (SP3). Executed query on New database: ...
0
votes
1answer
87 views

Upgrade MySQL Master Slave Replication Cluster from 5.7.22 to 5.7.24

I have a two node MySQL cluster with Master Slave replication. The MySQL version is 5.7.22 and the OS is CentOS. I need to upgrade the MySQL version to 5.7.24 due to some security reasons. However, ...
3
votes
1answer
123 views

mysql_upgrade check if it's neccessary to run it

How can I determine, do I need to run 'mysql_upgrade` command on database? Percona-server-5.6.41 is installed and running now for a several monthes. Before it mysql-5.6 was installed. In-place ...
3
votes
2answers
397 views

Upgrading SQL Server 2005 to 2016

I have a requirement to get rid of our old servers, however one of them includes a database server that is currently using SQL Server 2005. We have a new server running with 2016 so I wanted to know ...
1
vote
1answer
39 views

mysql_upgrade on fresh MySQL/MariaDB installation

What I've noticed lately is that whenever I install MariaDB or MySQL on a clean machine, and if I run mysql_upgrade it does the upgrading, so I figured since it's not showing it's already upgraded, I ...
0
votes
1answer
211 views

pg_upgrade --link fails: `directory “/…” already in use as a tablespace`

I'm attempting to upgrade from 9.6.2 to 10.5 using pg_upgrade My upgrade command (from OpenBSD pkg-readme): su _postgresql -c "cd /var/postgresql && \ pg_upgrade --link -b /usr/local/bin/...
0
votes
1answer
116 views

How do I configure my SQL Server instance to use a different Edition with minimal side effects?

I'm in the process of migrating an old server running Windows 2008 R2 with SQL 2012 Express to a new server running SQL Server 2017 Standard and Windows 2016. I would like to mirror databases between ...
1
vote
1answer
29 views

Table column length is fine in MySQL 5.5 and 5.6, but upgrading to 5.7 results in too many columns

So I have a CMS that is being upgraded from MySQL 5.5 -> 5.7. One table has a 1000+ columns, but it works fine in 5.5 and 5.6. When reaching 5.7, queries involving this table result in a 1117 error. (...
4
votes
0answers
171 views

Moving to version 2016 from 2008 and Breaking Change Alert from Upgrade Advisor

DBMS: SQL Server Upgrading from version 2008 to 2016. I have this part of the code that is being flagged by the Upgrade adviser as Breaking Change. Error: uses a constant expression which are ...
0
votes
1answer
175 views

Behavior Differences Running SQL 2017 in 130 Compat Mode vs. Running SQL 2016 in 130 Compat Mode?

We have a new application which includes ETL scripts, R, and .NET code all actively being developed on SQL 2016 architecture. I just recently received approval to start setting up new environments ...
2
votes
2answers
42 views

Upgrade SQL Server, not user databases

I have one machine we've been fighting to do an in place upgrade of SQL Server from 2016 SP2 CU3 to 2017. It keeps failing, but that's another topic. My question is, is there a way I can run the ...
0
votes
1answer
45 views

How to change all connections to SQL Server without investigating each hard-coded connection to serverName?

We've got a server upgrade scheduled for the near-future and we're looking to move to a new server. Our main issue is that we cannot have two servers with the same name on our domain. So is there a ...
-2
votes
2answers
112 views

SQL server migration - Server object listing/scripting tool [closed]

We need to quickly migrate multiple SQL Servers. We need a process to script out all server-level objects, e.g. linked servers, logins, jobs, server roles. We're looking for a tool to script out ...
2
votes
2answers
76 views

Upgrade in-place with low disk space on C: drive

I am due to upgrade SQL Server 2005 Express to 2014 Express. This will be an in-place upgrade. It's not my preferred way of upgrading, but being a physical machine and in a specific secure network ...
1
vote
1answer
113 views

SQL Server Upgrade - A new Approach for Upgrading

Microsoft's technical guide for SQL Server upgrade references two upgrade paths: in-place and side-by-side. I don't see a third, visibly more viable/convenient option, which is to do an in-place ...
0
votes
1answer
54 views

How to upgrade a MySQL database using numbered scripts based on a version field

I have a database that contains a version table with one value stored in it which is the database version number. I would like to be able to update the database version automatically using numbered ...
3
votes
1answer
311 views

Oracle 12 Startup upgrade throws error 443

Please follow the logic of my attempts at upgrade before suggesting a fix. The error 443 is not the main problem here. we are upgrading from oracle 11.2.0.4 to 12.2.0.1 on a Solaris 11.3 server '...
0
votes
0answers
50 views

dockerized postgresql listing no clusters

I'm upgrading an existing dockerized postgres:9.6 to 10. There are plenty of good Q/As on DBA and SO that go the path of pg_upgradecluster, but it is not working for me. When I start a vanilla pg:10 ...
0
votes
1answer
911 views

Mysql upgrade 5.7.22 to 8.0, server not starting after upgrade

I followed the upgrade guide Upgrading MySQL. Already installed version of mysql is 5.7.22 Verified all Upgrade Prerequisites for MySQL 5.7 Installation SET GLOBAL innodb_fast_shutdown = 1; then ...
0
votes
0answers
26 views

Upgrade MySQL 5.5 to 5.7 & catch up meanwhile data incremental data

In my organization we are going to upgrade MySQL server 5.5[MyISAM default engine] running on Windows. I have given new Windows server with same configuration like on prod server. now i will restore ...
2
votes
1answer
43 views

Reversion strategy when upgrading MySQL

We are planning to upgrade from MySQL 5.6 to 8.0 and are considering disaster recovery plans. We have three separate databases within our MySQL 5.6 instance which are 200Gb, 170GB and roughly 9GB. ...
0
votes
1answer
321 views

MySQL upgrade from 5.6 to 8.0

When trying to start MySQL 8.0 it complained about partially upgraded DD. Furthermore, it complained about not being to open a table S/AD.ibd which no longer exists there because we moved it to S/AD....
2
votes
1answer
110 views

SQL Server Patch Level Is Inaccurate, Causing Upgrade Issues

I have a box that lists SQL Server 2014 SP2 (12.2.5000) in both add/remove programs and the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\120\SQLServer2014\CurrentVersion\...
1
vote
1answer
671 views

Oracle Upgrade Standard to Enterprise Edition

I need to upgrade several Oracle Database 12c Standard Edition to Enterprise Edition. The only upgrade path I found is to reinstall the Oracle software. Is that the only way to upgrade?
0
votes
1answer
177 views

Mongodb upgrade from 3.0 to 3.2

I have upgraded the mongodb from 3.0.15 to 3.2 mongodb3.0.15 Configuration : Three shards Three config servers mongodb3.2 Configuration : Three shards Three config servers No replica sets I ...
0
votes
2answers
379 views

Analyze too slow after postgres upgrade

I'm working on a testing server to upgrade a large database, 700GB with around 20000 tables. The upgrade was fast enough using the --link option, but the analyze only script takes 8 hours, which is ...
2
votes
1answer
2k views

Can upgrade from MariaDB 5.5 to MariaDB 10.3 directly?

We have a database running in MariaDB 5.5.60 and we want to upgrade it to the last 10.3.7 version. However I'm looking at MariaDB knowledge base ( https://mariadb.com/kb/en/library/upgrading/ ) and I'...
1
vote
0answers
118 views

pg_upgrade: language “plpythonu” is not trusted

I'm trying to perform PostgreSQL 9.6 -> 10 upgrade with link method: /usr/lib/postgresql/10/bin/pg_upgrade --link \ --old-datadir=/var/lib/postgresql/9.6/main \ --new-datadir=/var/lib/postgresql/10/...
0
votes
0answers
85 views

pg_upgrade: Sequence-Check fails

After pg_upgrade one check fails. This SQL gets executed to list tables and their sequences. In comments to this question it is called "above sql". SELECT S.relname, T.relname, C.attname FROM ...
0
votes
1answer
46 views

Benchmarking procedures or Upgrade tests to be done after upgrading to SQL Server 2016 from SQL Server 2012

I need suggestions on how to benchmark performance or create baselines to test the upgrade from SQL Server 2012 to SQL Server 2016 (both standard edition), also if any post upgrade tasks that needs to ...
2
votes
3answers
1k views

How to repair mongodb service after an upgrade to Fedora 28?

I just upgraded to Fedora 28 and now my mongod service doesn't launch anymore. One possible solution that would fork in my case would be to be able to downgrade mongodb to 3.4, as the system upgrade ...
3
votes
2answers
3k views

Failure during install of SQL Server 2016 sp2

I'm trying to install the new SP2 for SQL Server 2016, but it fails during the install with an Engine error. This is what I can read in the errorlog> Error: 468, Severity: 16, State: 9. Cannot ...
0
votes
1answer
686 views

pg_upgrade issue from postgres 9.3 to 9.6

I am trying to use pg_upgrade to upgrade postgres server from 9.3 to 9.6. I have both binaries on the windows server R8. Here are the 2 pg_hba.conf : > 9.3 : # TYPE DATABASE USER ...