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
0
votes
1answer
18 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
5answers
82 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 ...
0
votes
1answer
550 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
1answer
1k 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
1answer
166 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 ...
1
vote
3answers
2k 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
0answers
146 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
2answers
923 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
1answer
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 ...
0
votes
0answers
88 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 ...
0
votes
3answers
8k 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
2answers
135 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
1answer
185 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
0answers
221 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 ...
0
votes
0answers
99 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
1answer
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
2answers
8k 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
1answer
143 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
2answers
861 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
2answers
13k 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
4answers
20k 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 ...