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
23 views
How often should MySQL (stock, Percona, etc.) be upgraded?
My organization runs several data-driven web applications backed by various flavors of MySQL on RHEL (i.e. we're just like everyone else!) Some of our web apps use the standard build of MySQL, and we ...
1
vote
0answers
54 views
Performance Hit when upgrading to Oracle 11gr2
I am experiencing the same symptoms as noted in this question which was closed and does not have a satisfactory answer.
Original Question
We've recently upgraded from Oracle 10gR2 (10.2.0.4 ) to ...
0
votes
1answer
35 views
In place upgrade from MySQL 5.5 to 5.6.11 removes all users from user table
On Windows, I upgraded from 5.1 to 5.5 no problem.
Copied my 5.1 data folder into my 5.5 instance
Started mysqld skipping grants
Ran mysql_upgrade
All good, but going from 5.5 to 5.6:
Copied ...
0
votes
1answer
17 views
Is it possible to upgrade mongodb cluster without upgrading arbiters?
Is it possible to have running real nodes with version 2.4 and arbiter nodes with 2.0 or 1.8 in the replica set?
Upgrade guides for version 2.2 and 2.4, did not tell anything about upgrading ...
1
vote
1answer
64 views
Is it possible to upgrade MongoDB from 2.0 to 2.4 directly
We have a replica set with 2 members and one arbiter in production. 10gen documentation states that 2.0 to 2.2 is a binary-compatible “drop-in" upgrade and so it's 2.2 to 2.4. Is it safe to upgrade ...
1
vote
1answer
48 views
What are the hazards of upgrading a SQL Server service pack?
Are there any specific pitfalls/standard considerations when upgrading an instance of MS SQL Server to a higher service pack? Is there anything special that is generally done besides making sure there ...
0
votes
2answers
63 views
Steps to upgrade MySQL from version 5.0 to version 5.5
I have been developing under MySQL v5.0 for a while now and need to upgrade to v5.5 to be in step with the hosted production server.
After having searched for precise steps to do this migration, I am ...
0
votes
1answer
22 views
replication breaks after upgrading master
I have a set up of replication with master 5.1.30 and slave 5.5.16
and the replication is working good
Now i have upgraded mysql master to 5.1.47
As far as i know we have to turn off the log bin ...
1
vote
1answer
47 views
MySQL upgrade 5.0.88 to latest
Very interesting and informative blog..
I have a question - i have a requirement of upgrading from 5.0.88 to latest version..
Why should i upgrade?
if so, which version should i consider?
What ...
0
votes
0answers
46 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
2
votes
1answer
118 views
Can a view affect ALTER TABLE commands?
I provide a database system to a number of customers. The database is installed locally on Oracle.
We periodically upgrade the database structure (either adding new fields, renaming old fields, ...
0
votes
1answer
172 views
upgrade mysql 5.1 to 5.5 on Ubuntu 11.10
I currently have mysql server 5.1 installed via apt-get on my production Ubuntu 11.10 server
root@Ubuntu-1110-oneiric-64-minimal$ dpkg --get-selections | grep sql-server
mysql-server ...
0
votes
1answer
97 views
SQL Server 2005 upgrade to Service Pack 4 (SP4) via command line
I have been wracking my brain over upgrading SQL Server 2005 to SQL Server 2005 SP4. I have a script for installing new instances of SQL Server for all versions and they all work wonderfully. Problem ...
3
votes
1answer
104 views
Problems executing pg_ctl during pg_upgrade from 9.0 to 9.1 on Windows
I'm trying to upgrade my 9.0 PSQL to 9.1 on Windows Server 2003. I've installed 9.1, stopped both services, and generally followed all steps on this guide. When I actually run the command, however, I ...
3
votes
2answers
203 views
Identify NON-ANSI joins in SQL Server 2008 R2 on a Database that's in 2000 (80) compatibility mode
We have a very old database running on SQL Server 2008 R2. The database is running in 2000 (80) compatibility mode and has oodles of NON-ANSI joins in stored procedures, views and functions.
We need ...
1
vote
1answer
77 views
Deleting folders after Oracle upgrade
I upgraded from Oracle 10g to Oracle 11g in Windows Server 2003.
New Oracle home : C:\app\oracle\product\11.2.0\db_1
Old Oracle 10g was installed on: C:\oracle\product\10.2.0\
Questions
Is the ...
25
votes
2answers
2k views
Are SQL Server in-place upgrades as ill advised as they used to be?
I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade.
I'm currently upgrading my 2008 R2 DEV and TEST ...
1
vote
1answer
125 views
Upgrade production database during software development lifecycle
Background
Using Oracle, there are a number of tools that help with migrating and applying development changes into the production environment (such as Embarcadero Change Manager). These tools can be ...
0
votes
0answers
279 views
Sybase ASA 9 Central exception on connecting to old database
I have installed sybase ASA 9 i used the sybase central to connect to an old version .db file of ASA version 6, a wizard popup and ask yes or no to unload the database .. for upgrade i click yes ...
3
votes
1answer
271 views
“Zero” downtime and minimal space requirements for upgrade to PostgreSQL 9.2
Need to migrate from PostgreSQL 8.3.x to 9.2
Constraint 1: 8.4 and above have made datetime format to be integer by default. Wasn't so in 8.3.x. As a result pg_upgrade can't be used. Unless server is ...
1
vote
1answer
82 views
Software/Hardware Upgrade
I've been working on a software/hardware upgrade from SQL2005 on win 2003 to SQL2008 R2 SP2 on win2008. The new hardware has 48 cores with 128 gig of ram whereas the older server 16 cores with 32Gig ...
3
votes
2answers
187 views
How to wait for PostgreSQL to be startable / restorable?
I'm testing a PostgreSQL 8.2.1 to 9.2 upgrade on a virtual machine running a custom Linux distro. The upgrade procedure is as follows:
Start the pg service
Vacuum all DBs (not sure if this is ...
2
votes
1answer
519 views
Migrating MySQL 5.0 to 5.5 - simple databases
I have a LAMP server on my LAN running a very old version of RedHat with MySQL 5.0, and I'm trying to migrate it to Ubuntu 12.04 to update it.
I know the advice is to migrate MySQL 5.0 to 5.1 then ...
1
vote
1answer
117 views
What happens to existing MySQL databases when I upgrade my Ubuntu distro?
I am in the midst of upgrading my Ubuntu distro from 10.4 to 12.4. Fearfully, it asked me for root password on MySQL when I was upgrading the distro.
I used to have databases on that server, would ...
1
vote
1answer
562 views
What are the most compelling reasons to upgrade from SQL Server 2005 to SQL Server 2012?
We currently have 2 SQL Server 2005 Enterprise machines in a mirrored environment running on Dell R815 servers. These machines consist of:
Four AMD Opteron 6176 Processors (12 cores at 2.3Ghz), for ...
2
votes
1answer
93 views
Cassandra upgrade/repair issues in migration
I wanted to migrate part of the column families in a cluster to a new cluster.
I made a snapshot of the source cluster and copied the data, made a new cluster with the same name, same number of nodes ...
0
votes
0answers
55 views
Upgrading from Oracle 10 to 11g, what to look for in SQL embedded in code?
We're planning to upgrade our enterprise database to 11g.
We have a number of web applications using it via Weblogic and Hibernate 3.6.5, and both of those support 11g.
There are a number of direct ...
0
votes
1answer
343 views
Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?
I have an existing 8.4 cluster (named main) that I want to upgrade to 9.1. However, when I go to upgrade it, I get an error because 9.1 already has a cluster named main (apparently a default cluster ...
0
votes
1answer
165 views
postgresql dump and load — need to dump “postgres” db also?
If I pg_dump a db from an 8.4 cluster, and then load it into a different 9.1 cluster, do I need to pg_dump and restore the 'postgres' db as well? (I'm not familiar with what is contained in the ...
4
votes
1answer
281 views
Why would a SQL Server 2008 R2 database disable a table index when upgraded to SQL Server 2012
I've restored a database backup in a new SQL Server 2012 server from a .bak made in SQL Server 2008 R2, and one of the tables has it's primary key index disabled. This doesn't happen when I restore to ...
1
vote
1answer
196 views
Is it possible to do an in-place upgrade of SQL Server 2005 Standard to SQL 2012 Enterprise?
At the moment, I have a SQL 2005 Standard box. I'd like to upgrade it to SQL 2012 Enterprise in-place. When I say in place, I mean an install similar to Office 2010, e.g. it removes the older (Office ...
3
votes
1answer
3k views
How do I copy databases from Postgres 8.4 to Postgres 9.1?
My trac server recently started having issues. It was running a very outdated version of Ubuntu, and I was unable to properly use apt-get to correct the issues I was having. So instead I backed up the ...
0
votes
2answers
279 views
MySQL upgrade on Ubuntu - any heads ups?
I am needing to upgrade MySQL on Ubuntu, it is a production server and naturally cautious.
My many googles look to be essentially saying that I need to :
Backup my current mysql database and ...
0
votes
0answers
182 views
Upgrading Java JDK for an Oracle 10g instance
Because of its security flaws, I need to remediate Java JDK 1.4.2. Based on this Oracle Blog, and encouraged by Do Oracle databases use Java internally and this Certification Matrix (opens an Excel ...
0
votes
1answer
220 views
Should I use mysql_upgrade after mysqld_safe when upgrading MariaDB?
I'm wanting to know the best practice to do a MariaDB upgrade on opensuse.
I am getting this error:
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db =
'a_database'': Cannot load from ...
3
votes
1answer
234 views
PostgreSQL memory spike upgrade from 8.2 to 9.1
We recently upgraded a few of our development computers from PostgreSQL 8.2 to 9.1, with plans on eventually upgrading our production servers. Everything seems well with the restore of the databases, ...
4
votes
1answer
226 views
Upgrade Postgres without doing a pg_dumpall
I'm upgrading from postgres 8.4 to 9.0 and looking at the manual it looks like this is my only choice:
pg_dumpall -p 5432 | psql -d postgres -p 6543
Which means I'll need to stop any writes to the ...
0
votes
2answers
1k views
oracle 10g xe to 11g xe upgrade
The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
1
vote
2answers
896 views
How to update SQL Server 2012 from Evalutation to Developer edition?
During the installation of a new development infrastructure, I had to install many SQL Server instances on different machines. Some were of course dedicated for production and some other for ...
0
votes
1answer
506 views
Upgrading 10g database to 11g database
Is doing a full data export (expdp) from an Oracle 10g (10.2.0.1.0) database and then doing an import of that dump file (impdp) into an 11.2.0.2 database a valid and acceptable upgrade path from 10g ...
4
votes
1answer
121 views
Is there a standard approach to rolling out database schema changes?
A developer said I should simply wrap all my database upgrade scripts in a transaction. If it fails, just roll back all changes. All my instincts tell me this is wrong, especially when it comes to ...
1
vote
4answers
1k views
upgrading sql server 2000 database to sql server 2012
Seeking some advice about an oudated database system we're working with.... hope this is an appropriate place to post this question.
I work with a city government arts program. In 2004, we ...
1
vote
1answer
389 views
Upgrade SQL Server database Using Compatibility Level
I've made a backup of a SQL Server database running on SQL Server 2008.
I've restored that backup into a SQL Server 2012 instance.
I've set the compatibility level on the restored instance to SQL ...
1
vote
2answers
376 views
pg_upgrade fails with an unspecified error
I’m running Postgres 9.1’s pg_ugrade to migrate from 9.0 to 9.1 on Windows x64. After editing the permissions to allow full trust, running the tool as the postgres user, and working around a bug ...
5
votes
1answer
91 views
Upgrade postgres without messing with ports?
The standard procedure for upgrading Postgres appears to require that I temporarily run both the old and the new version. This means that I have to change the port of the old version.
This seems ...
4
votes
1answer
86 views
Should the host machine always be restarted after upgrading an SQL Server 2008 instance?
My organization recently upgraded all its production SQL Server 2008 instances to Service Pack 3, Cumulative Update 1. It's my responsibility to make sure that our development database environments ...
1
vote
1answer
598 views
I am getting an error while trying to download binary for mysql 5.5.11
I am trying to upgrade MySQL 5.1 to 5.5.11 on Ubuntu 10.10. Everytime I try the wget command I get this error:
wget ...
4
votes
2answers
1k views
Which version of MySQL should I use?
For ages I have been using MySQL 5.1.37.
Recently I noticed that this version is no longer supported in repository, so I need to upgrade mysql.
I assume that changing the version should be ...
2
votes
1answer
1k views
Oracle DB hanging after upgrade to 11.2.0.3
The database is hanging randomly (with some leniency I would say almost each hour). Top session is:
select privilege#
from sysauth$
where (grantee#=:1 or grantee#=1) and privilege#>0
or
select ...
3
votes
1answer
1k views
Any Idea how to migrate from PostgresSQL 8.4 to PostgresSQL 9.1.1 in opensuse12.1
I had a crashed opensuse 11.3 that's why I installed opensuse 12.1..
after I installed (via yast) and edited /etc/passwd
I do this:
rcpostgresql start
and this shows on the /var/log/messeges
~ ...
