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.
26
questions
1
vote
2
answers
92
views
SQL Developer edtion as a new node within an Enterprise Availability Group
We currently have a 2 node Availability Group in our test environment running SQL Server 2017 Enterprise Edition.
I need to downgrade these both to Developer edition, since we are not using this in a ...
2
votes
1
answer
1k
views
How to Downgrade MySQL from 8.0.33 to 8.0.28
I need to downgrade because I cannot use MySQL for Excel add-in. How can I do it? I use windows 8.
There is no information on the MySQL's website.
1
vote
2
answers
897
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 ...
0
votes
1
answer
510
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 ...
1
vote
1
answer
2k
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 ...
0
votes
1
answer
117
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 ...
2
votes
5
answers
2k
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 ...
4
votes
1
answer
6k
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.
...
0
votes
1
answer
6k
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.
0
votes
1
answer
4k
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 ...
2
votes
3
answers
7k
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 ...
2
votes
0
answers
282
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 ...
1
vote
2
answers
2k
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 ...
-1
votes
1
answer
3k
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 ...
0
votes
0
answers
223
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 ...
1
vote
3
answers
14k
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 ...
2
votes
2
answers
392
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 ...
1
vote
1
answer
238
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 ...
2
votes
0
answers
327
views
SQL Edition Downgrade Impact on Jobs
We’ve made a downgrade from Enterprise Evaluation Edition to Standard and we saw the overnight jobs all running much longer. These are ETL packages and stored procedures to load data from an ...
0
votes
0
answers
111
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 ...
-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 [...
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.
1
vote
1
answer
147
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 ...
0
votes
2
answers
935
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 ...
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 ...
34
votes
4
answers
23k
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 ...