Questions tagged [downgrade]

In computing, downgrading refers to reverting software (or hardware) back to an older version; downgrade is the opposite of upgrade. Often, complex programs may need to be downgraded to remove unused or bugged features, and to increase speed and/or ease of use. The same can occur with machinery.

Filter by
Sorted by
Tagged with
1 vote
2 answers
39 views

how to downgrade mysql on Debian 10 from 8.029 to 8.02x

I have MySQL installed on my test server (Debian 10). I recently updated it to the newest version (8.0.29), but there are some issues with it so I want to go back to an older version (8.0.28). But I ...
user avatar
  • 1,920
0 votes
1 answer
27 views

db2 - Downgrade of upgraded instance and database?

So far I have always "upgraded" database using clean install (new Linux install etc) inside virtual machine. But now I have requirement to upgrade Db2/Linux from Db2 v11.1 to Db2 v11.5 ...
user avatar
  • 57
1 vote
1 answer
138 views

Can I downgrade from SQL Server 2017 CU25 to CU20?

New instance of SQL Server 2017. I chose to install up to CU25 during the initial installation. Been using the database for a few months, but it seems to have a memory leak when using memory-optimized ...
user avatar
  • 123
0 votes
1 answer
41 views

Can I downscale/upscale my MySQL server automatically?

Is this doable? Since we know the peak times of our platform we are planning to downscale our DB after peak hours then upgrade the specs before the start of peak hours, how can we do this? Like how is ...
user avatar
  • 59
2 votes
5 answers
494 views

CREATE Windows User in database for not existing domain

Is it possible to create a Windows User in the database when the domain is not accessible? I am preparing database at my dev environment outside of the targeted domain. Created user is not expected to ...
user avatar
  • 935
1 vote
1 answer
2k views

How to prevent pg_dump from generating "SET default_table_access_method=heap;"?

I have a big dump file that is generated by pg_dump that comes with PostgreSQL v12 client, and it is in customized format instead of plain sql text. The version of the server is PostgreSQL v12 too. ...
user avatar
  • 157
0 votes
1 answer
3k views

How to properly downgrade mysql 8 to 5.7 in centos 8

I would like to downgrade MySQL 8 to MySQL 5.7 on centos 8, can I get the proper steps/commands. Thanks in advance.
user avatar
0 votes
1 answer
811 views

Downgrade SQL Server from Enterprise to Developer edition in an Availability Group

I will be transitioning some non-production SQL environments from Enterprise to Developer edition over the next few months. I'm pretty settled on the procedure I will be using, which is laid out in ...
user avatar
2 votes
3 answers
4k views

Can we downgrade from 19c to 12.1.0 if the compatibility is set to 12.2.0

Team: Recently i upgraded a 12.1.0 database to 19c (non CDB architecture). Current compatibility is set to 12.2.0. Can I downgrade it to the earlier version - 12.1.0? Documentation states the ...
user avatar
  • 27
2 votes
0 answers
197 views

What kind of complications would I face downgrading from MySQL 8 to MySQL 5?

Let's assume I wanted to downgrade to from MySQL 8 to MySQL 5.7. I know this isn't supported, but what kind of complications am I likely to encounter. The docs say, The only supported alternative ...
user avatar
  • 55.7k
1 vote
2 answers
1k views

Downgrading SQL Server database and moving it to another computer

I have created database on my computer using SQL Server 2019, and now i want to move it to another computer that has SQL Server 2014 installed on it. Do I have to download SQL Server 2014 and ...
user avatar
  • 19
-1 votes
1 answer
2k views

How to downgrade sqlite3 that comes with Python and Django

So I am stuck in this problem: https://stackoverflow.com/questions/53637182/django-no-such-table-main-auth-user-old I can't upgrade Django because many other applications are connected to it using ...
user avatar
  • 139
0 votes
0 answers
114 views

Restoring backup with a MySQL Database downgrade

I want to migrate a MySQL 5.7 database to a MySQL 5.1 version because the MySQL version of the server I’m migrating my WordPress webpage is 5.1. I tried to do it in the usual way but it was not ...
user avatar
1 vote
3 answers
10k 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 ...
user avatar
  • 273
2 votes
2 answers
209 views

Can I install SQL Server 2012 Express edition on a same machine with 2012 SQL Server Standard version

As I would like to say that we are going to downgrade the SQL Server Standard 2012 SP1 edition with SQL Server Express 2012 SP4 in one Production Server. For the time being I want to keep the SQL ...
user avatar
1 vote
1 answer
203 views

SQL Server 2014 Edition Downgrade

I have a SQL Server 2014 Standard Edition used by my devs to test their applications pointing to a common instance. Lately I've been informed that for this purpose I can use Developer Edition, that it ...
user avatar
  • 13
2 votes
0 answers
236 views

SQL Edition Downgrade Impact on Jobs

we’ve made a downgrade from Enterprise Evaluation Edition to Standard and we saw the over night jobs all running much longer these are ETL packages and SQL Stored Procedures to load data from ...
user avatar
  • 41
0 votes
0 answers
105 views

SQL Server 2008 R2 warning when tried to execute the script of size approx 500MB [duplicate]

When I tried executing a SQL script, which was of 500MB approx. Management Studio throws an error Insufficient memory to continue the execution of the program My system memory is 8GB and only 3GB ...
user avatar
  • 852
-1 votes
1 answer
3k views

Got error while reverting mysql 5.7 to mysql 5.6

Got error while doing mysql service restart. Googled a lot, but nothing fix my issue. [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 2016-04-23 11:10:38 22185 [...
user avatar
1 vote
2 answers
9k views

How to downgrade SQL Server 2012 Enterprise to 2012 Express?

I would like to say that as per company policy we are downgrading SQL Server 2012 Enterprise to SQL Server 2012 Express. Any suggestion would be appreciated.
user avatar
1 vote
1 answer
145 views

Is my mssql 2008 standard suitable for web edition 2014

A web edition seems enough for me when I read this. I thought it had a 2gb size limit before? I have three databases our current db and am not doing anything fancy. Just some server agent jobs from ...
user avatar
0 votes
2 answers
890 views

Is it possible to downgrade oracle 11.1.0.6.0 to 10.2.0.4.0?

Is it possible to downgrade oracle 11.1.0.6.0 to 10.2.0.4.0? The Compatible parameter need to be changed to "10.2.0"? Today I have Compatible set to 10.2.0.4.0. It's not clear on support.oracle if I ...
user avatar
  • 1
2 votes
2 answers
14k views

Downgrade SQL Server Enterprise Edition to SQL Server Standard Edition

There is a requirement in our project where they want to evaluate if it is possible to downgrade SQL Server from Enterprise to Standard edition and if a server can be decommissioned. How can I ...
user avatar
  • 6,950
35 votes
4 answers
21k views

How to move a database from SQL Server 2012 to SQL Server 2005

What are my options if I need to move a database from SQL Server 2012(32bit) to SQL Server 2005(64bit)? I know I cannot: restore a backup of the database on SQL Server 2005 detach & attach I ...
user avatar
  • 1,005