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.

learn more… | top users | synonyms

36
votes
3answers
4k 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
222 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
453 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
534 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
90 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 ...
4
votes
2answers
339 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
2k 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
174 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 ...
2
votes
1answer
1k 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
134 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 ...
1
vote
1answer
755 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
219 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
386 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
366 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
2answers
5k 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
404 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
1answer
345 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
299 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
401 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
2k 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
2k 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
876 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 ...
5
votes
1answer
188 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
3k 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 ...
3
votes
1answer
531 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
444 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
109 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
106 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
812 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
2k 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
2k 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
2k 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 ~ ...
2
votes
2answers
521 views

Which first: upgrade mysql version or convert storage engine?

I inherited a production mysql server at 5.0. It uses MyISAM exclusively. It is not a high volume database but it does have some large datasets. I am planning on: upgrading to 5.5 converting ...
7
votes
2answers
179 views

Meeting with DBAs regarding server upgrade project - Common concerns

I'm more of a network/windows admin and I've been tasked with overseeing a SQL server upgrade project. I need to meet with the DBAs and discuss their needs / wants regarding the upgrade. I don't want ...
1
vote
1answer
3k views

How to upgrade MySQL to newer version on existing database

I am having data of 20 GB with MySQL version 5.0.24. Now I want to update MySQL to newer version 5.5.16. We can do it by taking complete database backup and uninstall old MySQL and install new MySQL ...
5
votes
2answers
244 views

What is an advantage or disadvantage for not upgreading database server?

I have a legacy database server. The person who wrote it is long gone. There is no documentation at all just some comments in the code. Luckily, it is not that complicate but if I want to fix it ...
0
votes
2answers
374 views

Upgrading Instances with Mirroring

If you want to upgrade or install a patch on two separate instances that house both the principal and mirrored database, how can you go about that? If the database that is being mirrored needs to be ...
6
votes
2answers
3k views

How Long Would Take to Upgrade an 1T Oracle DB from 10g to 11g?

How long would take to upgrade an Oracle DB which has 1T data from 10g to 11g usually/roughly? I need to estimate the down time for it since it is a prod db. Thanks much!
1
vote
3answers
189 views

PostgreSQL: 8.3/8.4 interface chages?

I would like to upgrade a PostgreSQL 8.3 server to PostrgreSQL 8.4. There are many software components that interact with the server over the network, and I am concerned with compatibility issues. Is ...