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

0
votes
0answers
5 views

“Display width out of range for column” error when importing mysql 5.1 dump into 5.5

I am migrating to a new server, and trying to move my database from a 5.1 to 5.5 server. I created a dump with mysqldump -u root -p --add-drop-database --triggers dbname > dbname.sql When I ...
1
vote
0answers
23 views

How to apply a patch to pgAdmin III 1.18.1 on Windows?

A follow-up question to this one: How to apply a patch in PostgreSQL on Windows? There is a lot of .patch files distributed everywhere, but no hints how to apply them (at least no hints that wouldn't ...
4
votes
1answer
137 views

How to apply a patch in PostgreSQL on Windows?

How to apply a patch in PostgreSQL? I found an advice, but it seems to be suited for *NIX only. My PostgreSQL (9.3.1 EDIT: 9.3.4 now) was installed from an exe installer on Windows XP (32 bit), so I ...
5
votes
2answers
72 views

Altering db schema in production environment

I have some questions on db schema changes in production environment without taking the database server and the webapp offline. Q1- I want to be able to make changes to database schema (adding, ...
0
votes
1answer
31 views

Can I have Oracle primary 11.2.0.1 and standby 11.2.0.3?

Can I have data guard system like: Primary: 11.2.0.1 Standby: 11.2.0.3 In logical standby ? In physical standby versions(releases) must be the same?
1
vote
2answers
36 views

how to upgrade and migrate postgres dbs to new server machine?

my production databases run on a centos 5.5 virtual machine. This server has 2 postgres 8.4 clusters installed on 2 different partitions; now my idea is to upgrade both db version and server os ...
2
votes
2answers
52 views

pg_dump/pg_restore: different PostgreSQL version, another database name, another tablespace

I am going to move a database from the old server to a new one. the old one runs PostgreSQL 9.1, the new one has 9.3. I want to change the database name. I want the new database to be in a dedicated ...
1
vote
1answer
52 views

MySQL 5.5 to 5.6 Upgrade. Will data remain the same?

We are considering to upgrade to MySQL 5.6 this summer. I would like to know if our data will be changed in any way once we perform the upgrade? I've been reading and I found that mysql_upgrade ...
0
votes
0answers
57 views

Mysql replication broke after mysql upgrade on master

I've seen this question, but I am not sure if the solution is right for my particular error (replication breaks after upgrading master) I upgrade my master server's mysql from 5.5.34 to 5.5.35. After ...
0
votes
1answer
51 views

SQL Server 2008 mirroring migration to SQL Server 2012 always on

Quick question, request your input. I am migrating a SQL Server 2008 R2 instance with database mirroring to SQL Server 2012 with always on. Should I : Restore the SQL Server 2008 R2 backup to SQL ...
0
votes
0answers
32 views

Post Database upgrade on new instance [duplicate]

I reviewed the SQL Server 2012 technical upgrade guide and also googled for more recommendations. I am migrating a SQL Server 2008 R2 instance to SQL Server 2012 on a separate machine. Here is what ...
1
vote
2answers
63 views

Database restore on new server and upgrade to SQL Server 2012

I have to move a 5 TB SQL Server 2008 database that has mirroring setup to a new server that will have SQL Server 2012 and always on AG setup. I am wondering if detach/attach would be faster or ...
1
vote
2answers
90 views

Upgrading to SQL Server 2012 from SQL Server 2008

I have upgraded my SQL Server 2008 R2 Enterprise edition to SQL Server 2012. Even after upgrade I can see & use SQL Server 2008 R2 instance without any issue. Did my upgrade went fine? I can ...
2
votes
1answer
116 views

Issue while upgrading SQL Server 2012

When I tried to upgrade SQL Server 2008 R2 to SQL Server 2012 everything went well except below issue How do I fix it? Do I need to uninstall SQL Server 2012 again? EDIT Feature: ...
0
votes
0answers
42 views

How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0? [duplicate]

I have SQL Server 2012 with version 11.0.3000.0 . I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...
1
vote
2answers
737 views

How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0?

I have SQL Server 2012 with version 11.0.3000.0 . I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...
0
votes
0answers
11 views

Reducing schema to shrink real-world data to a functional subset

I work with two editions of a shipping product; call them "A" and "B". Both use similar a database schema, but edition "B" has a strict super-set of the schema (and features) used for edition "A". ...
1
vote
0answers
50 views

SQL Server 2008 upgrade and clean

After upgrading a SQL Server 2008 instance to SQL Server 2012 (in-place upgrade), there appears to be numerous 2008 instance components (namely the 2008 SSMS in start menu, in add/remove programs ...
0
votes
0answers
93 views

Install 10g XE on 64bit linux

As I know there is only 32bit version of 10g XE, am I right? And the installation file is called "oracle-xe-univ-10.2.0.1-1.0.i386.rpm". I want to install it on Centos 6.4 64bit. But during the ...
1
vote
1answer
199 views

How to do a minor upgrade postgresql 9.3.0 windows to 9.3.1?

What is the recommended way to perform an upgrade from PostgreSQL 9.3.0 to 9.3.1 (minor upgrade) using the Enterprise DB built windows installer? Should I uninstall first or just install over the ...
1
vote
0answers
96 views

How to upgrade MySQL 5.0 to 5.5 with master-master replication?

I have to update 2 hosts with SUSE Linux Enterprise 11 from SP2 to SP3 which implies an update from MySQL 5.0.94 to 5.5.31. The release notes state: SLE 11 SP3 introduces the upgrade of the MySQL ...
0
votes
0answers
34 views

Converting MySQL 5.6.10 - 32 bit to 64 bit version

I am currently using MySQL DB Version 5.6.10 for 32 bit running in 64 bit Window OS.I want to change it to 64 bit without taking any dump..Can anyone help in this?
2
votes
2answers
295 views

SQL Server 2008 upgrade to SQL Server 2012 on a cluster

I have a Windows 2008R2 2 node cluster with SQL Server 2008 clustered. How do I prevent the cluster from failing over while I am applying the SQL Server 2012 to the alternate node first? Any pointers ...
1
vote
1answer
527 views

pg_upgrade unrecognized configuration parameter “unix_socket_directory”

I'm trying to upgrade Postgresql from 9.2 to 9.3 in Fedora 18 using this command as the postgres user $ pg_upgrade -b /bin -B /usr/pgsql-9.3/bin -d /var/lib/pgsql/data -D /var/lib/pgsql/9.3/data/ -j ...
1
vote
1answer
82 views

Upgrading MySQL 5.1 to 5.5 - All tables gone [closed]

I'm trying to upgrade from MySQL 5.1 to MySQL 5.5. I followed the instructions here: http://dev.mysql.com/doc/refman/5.5/en/windows-upgrading.html I also adjusted the Datadir. But after the upgrade, ...
1
vote
2answers
127 views

Install SP 3 on SQL Server 2008, where merge replication is running

I have a SQL Server 2008 and I should install Service Pack 3 for it. On my server there are several databases replicated, and mobile devices sync data via merge replication. Can problems occur, if I ...
1
vote
1answer
924 views

Upgrading MySQL 5.1 to 5.5 on Centos 6 without removing dependencies

I'm trying to upgrade MySQL 5.1 to 5.5 using yum/rpm combo (yum to remove MySQL 5.1 and rpm to install MySQL 5.5). Most instructions I've found suggest to do first: yum remove mysql mysql-server ...
1
vote
2answers
377 views

Changing the mysql.proc table directly after upgrade

Our host upgraded our mysql install without us knowing from roughly 5.1 to 5.5. This caused a problem because the table definition of mysql.proc is different as discussed here: ...
1
vote
1answer
269 views

10g to 11gr2 upgrade causes SYS.UTL_HTTP malfunction

After a 10g to 11gr2 upgrade, we are getting ORA-29273 errors when we try to use the SYS.UTL_HTTP package. Our upgrade list requires ACL to be disabled. How can we resolve this problem without ...
0
votes
1answer
115 views

pg_upgrade fails with lc_ctype cluster values do not match

I'm upgrading my PostgreSQL version 9.1.4 database to version 9.2.4. Both the old and the new version are the bundled versions of postgresapp.com for Mac OS X. When trying to upgrade the database I ...
0
votes
1answer
58 views

Hazards of Upgrading SQL Server Express 2008 to R2

A client of mine reached the 4GB database limit on a SQL Server 2008 Express. As a test I installed the R2 version on another machine and restored a backup of the database. I'd like to upgrade the ...
-2
votes
0answers
172 views

SQL server 2012 upgrade causing reindexing to take a long time / fill up log file [closed]

I have a customer who has upgraded their SQL Server from SQL Server 2005 to SQL Server 2012. According to them, no other changes were made. They have an ERP database which does a full reindex once a ...
1
vote
1answer
170 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
161 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
1k 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
42 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
533 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
167 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
282 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
126 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 ...
2
votes
1answer
519 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
1answer
2k views

Upgrade SQL Server 2012 Express to Evaluation Edition

Is there a way to upgrade an instance of SQL Server 2012 Express to SQL Server Evaluation Enterprise? I tried using the SQL Server Installation Center and clicking Maintenance, and then Edition ...
2
votes
1answer
587 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
390 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
480 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
2answers
388 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
519 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
189 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 ...
8
votes
2answers
105 views

Read ancient Oracle database into current Oracle version

An old computer with Oracle 8i is dead. We have the daily backup of the database (C:\oradata). We are unable to install this old Oracle version anywhere because we don't have the install CDs for it. ...
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 ...