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.

0
votes
1answer
44 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
38 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
65 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
28 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
106 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
277 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
60 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
67 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
57 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 ...
2
votes
2answers
154 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
34 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
130 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
99 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
21 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. (...
3
votes
0answers
94 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
168 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 ...
0
votes
1answer
43 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
104 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
61 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
50 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
250 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
40 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
645 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
41 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
268 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
97 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
549 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
121 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
293 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
1k 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
108 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
77 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
44 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
2k 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
0answers
55 views

what version of postgresql 9.6.8 with what version of postgis

I am a bit confused with the upgrade of a dataserver postgres from 9.3 to 9.6.8. Despite the readings of http://postgis.net/windows_downloads/ and the board (not up to date) https://trac.osgeo.org/...
0
votes
1answer
497 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 ...
0
votes
1answer
120 views

Methods for right-sizing SQL Server virtualization?

I am starting to plan a migration of SQL Server 2008 R2 Enterprise Ed. to 2017 (edition TBD). One of the more important tasks assigned to me is to determine the specs for the new VMWare hardware my ...
1
vote
1answer
541 views

SQL Server update from SP1 to SP3 [duplicate]

Can I move directly from SQL Server SP1 to SP3 or do i need to install SP2 then go to SP3. I was assigned to upgrade my servers 2014 just to make sure I don't fall into problems
22
votes
3answers
2k views

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 ...
0
votes
1answer
205 views

Oracle PDB broken after upgrade from 12.1 to 12.2

We upgraded our development environment Oracle 12.1 RDBMS to 12.2 version. The CDB contained 3 PDBs of which 2 upgraded nicely but 1 did not. The resulting situation is that during the upgrade SYSTEM ...
0
votes
0answers
54 views

SHOW DATABASES query slower after mysql upgrade

I am experiencing some slowness with show databases/show tables query after upgrading mysql from 5.6 to 5.7.I am also experiencing some slowness on phpmysqmdin when pulling databases and tables as ...
1
vote
0answers
202 views

Collation Conflict when patching SSRS

We recently upgraded our test database servers from SQL 2014 SP2 CU3 to 2014 SP2 CU10. Most of the servers are fine, but on 2 of them we are getting the following error when connecting to the ...
2
votes
2answers
464 views

Update expiring Mongo cluster SSL certificate

I have a multi-node mongo cluster using SSL requireSSL and the certificates are going to expire. Is there a zero-downtime method to update the certs? I know the easiest way would be to stop all nodes, ...
1
vote
1answer
266 views

postgres pg_upgrade 9.2 to 9.5 problem

I'm trying to upgrade from 9.2 to 9.5 using the pg_upgrade tool. I'm using CentOS 7.0 current postgres bin folder: /opt/rh/postgresql92/root/usr/bin new postgres bin folder: /opt/rh/rh-postgresql95/...
0
votes
1answer
847 views

How to Recover My database From Old WampServer?

Previously I am using wampserver2 with "mysql5.6.17" version.I have many database in that version. I uninstall the wampserver and install new latest version wampserver3.1.0_x64. Before uninstalling ...