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

5
votes
2answers
11k views

How to upgrade postgresql 8.4 to 9.4

I want to upgrade my postgresql 8.4 to 9.4. the documentations are not clear to me. Will I lose my old databases if I do the upgrade? How can I backup my old databases if I am to lose them after ...
1
vote
1answer
29 views

ERROR 1091 (42000): Can't DROP 'PRIMARY'; on “mysql_upgrade”

I updated MySQL from 5.5.50 to 5.6.31 on a Centos 6.8 box with Plesk 12.5.30. Using those steps. The upgrade was successful but I ran into trouble with mysql_upgrade. I had to rebuild the permission ...
4
votes
1answer
266 views

Upgrade from Postgres 9.3 to 9.5

I’m attempting my first upgrade of Postgres from 9.3 to 9.5. I’ve run into two roadblocks but not sure how to get around them. I have my 9.3 PGDATA set to /data/postgres, which is a separate ...
0
votes
0answers
10 views

Database patch management approach for client-hosted databases

I currently develop software (.NET WinForms) for enterprise customers. My customers host their MS-SQL database for my application internally (on-premise) and I don't have access to it. This has meant ...
-3
votes
1answer
42 views

Upgraded to SQL Server 2012 and sql server agent scheduled jobs run twice

We recently upgraded from 2008 to 2012 and with one of our applications running on a ACTIVE & PASSIVE server (Always On) it has been running twice at the exact same time. We verified it wasnt ...
5
votes
1answer
150 views

Cluster node upgrade of SQL Server 2008 R2 to SP3 fails when moving resource

I'm trying to update a cluster to SQL Server 2008 R2 SP3. I've installed SP3 on the passive node but when I failover the cluster it errors when running through it's upgrade scripts. The messages &...
0
votes
2answers
59 views

Upgrade a database from SQL Server 2000 to SQL Server 2014

I have database in SQL Server 2008 R2. I took a backup of this database and restored that on a SQL Server 2014 server. However, some of the database queries are not looking compatible to the new ...
2
votes
0answers
69 views

After upgrade to 2016, can't view SQL Server Logs

Just upgraded to SQL Server 2016 from SQL Server 2014 SP1 CU4. This is a clustered instance I am no longer able to use xp_readerrorlog and xp_enumerrorlog Msg 22004, Level 16, State 1, Line 10 ...
3
votes
1answer
266 views

After Upgrade to 2016, SQL Server Agent can't connect to Instance

On a clustered Windows 2012 R2 server with SQL Server 2014 Enterprise. Just upgraded an instance from 2014 SP1 CU4 to 2016 RTM and now getting this error when attempting to start the SQL Server ...
0
votes
1answer
148 views

Upgrading Cassandra

my Cassandra version is 1.2.4 and i'm trying to upgrade it to 2.0.5 and i know that in the first part i have to upgrade it to 1.0.14 and after that try to upgrade it to the 2.0.5 , when I try to run ...
9
votes
1answer
168 views

Can I tell when and who updated my database from v11 to v12 on Azure?

Earlier today I noticed that all my Azure SQL database servers where updated from v11 to v12. I am the only one in my company that should be touching those dials, but not the only person in my company ...
2
votes
1answer
39 views

Geography data type and Upgrading from 2008 r2 to SQLServer 2014

I am getting a warning about a data type called geography. Our system has 1 column of data type geography. I am trying to figure out if the upgrade will fail or just if an app may have an issue. ...
0
votes
1answer
30 views

Upgrading SQL Server 2008 failover cluster node to SQL Server 2012 failover cluster node [closed]

Please I want someone to help me with step by step method of upgrading SQL Server 2008 with failover cluster node on two different machines to SQL Server 2012 without losing the existing settings/...
1
vote
0answers
42 views

Replacement for transactional replication

My colleagues and I have to migrate a database from SQL Server 2008 R2 to SQL Server 2012. Schema, triggers, stored procedures etc. are working fine. But we also have to "migrate" the replication ...
1
vote
0answers
26 views

PostgreSQL: pg_upgrade failing because hstore incompatible

I'm trying to migrate from PostgreSQL 9.4.5_2 -> 9.5.3 I'm trying to use pg_upgrade (from 9.5.3 distribution) and getting the following error: pg_dump: [archiver (db)] query failed: ERROR: ...
0
votes
0answers
437 views

errors install and start postgresql-9.5

UPDATE Why I run "sudo apt-get purge postgresql-9.4 postgresql-client-9.5 postgresql-client-common postgresql-common" and everything is OK??? My ubuntu is 12.04.1. Does it matter with this? I ...
1
vote
0answers
21 views

How can I upgrade PostgreSQL while using PgQ queue system?

I'm using PostgreSQL 9.3 and PgQ 3.2.6 for about two years and now it's time to upgrade. I found out that upgrading PostgreSQL is fairy simple. Just install new Postgres version and then: sudo ...
0
votes
0answers
19 views

Apache Cassandra 2.0.12 is not compactable with 2.1.X version

I am trying to upgrade my cassandra from C* 2.0.12 to C* 2.1.13 version. I am following the upgrade procedure as specified in DataStax doc As per the C* CHANGES.txt file, it's clear that upgrade to ...
0
votes
1answer
29 views

SQL Server 2008 R2 Enterprise Evaluation

Was hoping someone could assist me on finding the SQL Server 2008 R2 Enterprise Evaluation? I am trying to create a test environment for a SharePoint migration, and part of the step is from WSS 3.0 ...
0
votes
0answers
15 views

How to upgrade PostgreSQL 7.3 to 9.3?

I want to upgrade the PostgreSQL database from 7.3 to 9.3. Please help me how to perform the upgrade.
1
vote
1answer
65 views

Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible

We have a legacy application that is only used for a read only reference. It is using SQL Server 2000. We want to migrate its database to SQL version 2012, however we can't upgrade the software and ...
0
votes
1answer
80 views

Upgrading SQL Server 2012 Enterprise SP1 (11.0.3000.0) to SP2 or SP3

We need to upgrade our production SQL Server 2012 Enterprise SP1 (11.0.3000.0) to SP2 or SP3. So which one would be more stable out of those 2 service packs and also how could this be achieved with a ...
2
votes
1answer
54 views

Can mirroring be used to upgrade SSRS?

Can you use mirroring to upgrade SSRS? For instance, I've upgraded from SQL 2005 to SQL 2014 with mirroring. SSRS is running on the same box as my database server. I'm going from SQL 2012 (11.0....
0
votes
0answers
36 views

MySQL Upgrade query

I have 5.5.44-log MySQL Community Server (GPL) running in one of my RHEL 6.4 server. I need to upgrade the server to Percona Server-5.6.29-76.2. How to go about the upgrade? Should I completely remove ...
1
vote
0answers
47 views

Warning after upgrading from dockerized postgres 9.3.10 to Postgres 9.5.2

I've just finished an upgrade on an Ubuntu box with a dockerized Postgres container. The upgrade appears to have gone off great. But when log in to the docker container/server I get a warning message: ...
-3
votes
1answer
13k views

What is the Difference between SQL Server 2008R2 and SQL Server 2014?

I want to take my project from SQL Server 2008 R2 to SQL Server 2014. But I want to learn what is T-SQL the difference between 2008 R2 and 2014 for Database Engine? I mean is there any end of life ...
2
votes
2answers
61 views

SQL Server - SQL Plan Management for baseline

I am a .Net developer. I have a database upgrade coming up (from SQL Server 2005 to SQL Server 2012). The database team will be handling the migration. But I have seen forums posts saying that after ...
5
votes
1answer
1k views

Reporting Service 2014 Service Pack 1 Failing to work with error - wrong database version

Tonight we upgraded our SQL Server 2012 (SP2+CU6) cluster with SQL Server 2014 Service Pack 1. On that cluster nodes, we have Native mode Reporting Services scale-out configuration. After in-place ...
3
votes
2answers
3k 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 ...
0
votes
1answer
447 views

How to restore data after MySQL Upgrade?

I upgraded from MySQL 5.5 to 5.6 by uninstalling 5.5 and then installing MySQL 5.6. Now that MySQL 5.6 is running, none of my DBs or data is present/visible in MySQL Workbench. I also see that I ...
1
vote
1answer
116 views

Inplace upgrade from SQL Server 2008 Standard to SQL Server 2014 evaluation

I am trying to evaluate SQL Server 2014 by using the 2014 evaluation edition to upgrade an in place SQL Server 2008 Standard sp4 instance. At the end of the process I expect to have a SQL Server ...
0
votes
1answer
51 views

What are the low hanging fruits of a SQL Server 2014 migration?

I have read about new features and changes of the SQL Server 2014 version. But I still don't know the benefits every server will have by upgrading (from 2008 R2) to 2014? Are there any new features /...
0
votes
0answers
271 views

Postgres 9.4 to 9.5 using Yum and pg_upgrade - CentOS 6.7 (Final)

I am attempting to do an upgrade between Postgres 9.4 to 9.5 on a CentOS 6.7 system. I have reviewed both: http://www.postgresonline.com/journal/archives/362-An-almost-idiots-guide-to-install-...
1
vote
0answers
35 views

Upgrade cluster sql server 2014

How can I upgrade SQL Server cluster 2012 to SQL Server 2014? Version – Standard. We have 2 nodes and 2 instances on each node. Have you manuals for upgrade 2 instances on cluster SQL Server 2014 We ...
0
votes
2answers
35 views

A good way to verify if the update has no problems?

I don't know if this is a stupid question, but I'm upgrading my test instances to SQL Server 2014. I've installed SP1, after I will install Cumulative Updates. It's working fine, but is there a way ...
7
votes
3answers
495 views

Risks involved in upgrading to SQL Server 2008 R2

We have quite a number of SQL Servers that need to be upgraded from version 2005 to 2008 R2. Work is planned before the middle of the year as Microsoft is ending its support for the same. The 2005 ...
4
votes
1answer
92 views

Why is my @@Version unchanged after upgrading?

I have SQL Server 2008 R2. I installed SQL Server 2014 with the option: Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 and the process ended correctly. But ...
5
votes
1answer
2k views

SQL Server AlwaysOn database stuck in Not Synchronizing / In Recovery mode after upgrading. Error: Cannot open database '…' version 782

While testing an upgrade from SQL Server 2014 SP1 (12.0.4422.0) to SQL Server 2016 CTP 3.2 (13.0.900.73) I was following the recommended update process and ran into an issue where the database would ...
1
vote
1answer
472 views

Upgrade PostgreSQL 9.4 to 9.5 : LC_ALL unset

I'm trying to upgrade my PostgreSQL 9.4 database to PostgreSQL 9.5 but everytime while running sudo pg_upgradecluster 9.4 main I get this error: Stopping old cluster... Disabling connections to the ...
2
votes
1answer
121 views

Upgrading SQL Server 2008 Standard to Enterprise

I'm trying to do the upgrade but when it asks me for the Product Key for the current version, I can't find it. When I go on the MSDN website for it, it says that a key is not necessary for this ...
2
votes
1answer
1k 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 ...
5
votes
2answers
701 views

My HD crashed and I can't start MySQL

I am on Windows 8, my SSD got corrupted and I installed Windows on a new drive. I had before MySQL 5.6.12, now I installed 5.6.17 and tried to move the entire data dir. The location of the MySQL ...
1
vote
1answer
20 views

Move data from mysql 4.0 to 5.6 without corrupting encoding

I have a old mysql database that I would like to move to a recent version of mysql and optimize for SELECT ... WHERE ... statements. It is going to be a SELECT only database. Original database uses ...
64
votes
5answers
16k 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 ...
0
votes
2answers
3k views

MySQL 5.5 Fail start Fedora 16

I installed mysql and mysql-server from the repos (MySQL version 5.5). Then tried to start it, but got an error. [root@server]# service mysqld start Redirecting to /bin/systemctl start mysqld....
4
votes
1answer
5k views

SQL Server performance is slow when migrated from SQL Server 2012 to SQL Server 2014 [duplicate]

We are trying to migrate from SQL Server 2012 to SQL Server 2014 on Windows 2012 R2 OS. After the upgrade, we are doing performance testing and observed huge difference in running a simple query from ...
0
votes
2answers
546 views

Oracle database patch update doubts

Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1) says the following 4 patches are recommended to be applied to 11.2.0.4 database. Note:21744343.8 Combo of 11.2.0.4.5 OJVM PSU and 11.2....
0
votes
1answer
30 views

Upgrading a big database inside a transaction

Assuming a big database, where normal upgrade (structural changes and data upgrade) currently takes about 2-3 days (not a issue, is not done during production and about 1-2 times per year. Currently, ...
0
votes
1answer
54 views

Upgrade from SQL Server 2008 R2 SP2 to SQL Server 2014 Error

I am upgrading from SQL Server 2008 R2 SP2 to SQL Server 2014 and receiving an error I cannot get past. Everything checks out before the upgrade runs. The upgrade stops at ...