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

1
vote
1answer
39 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
45 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 ...
0
votes
0answers
35 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 ...
2
votes
1answer
53 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 ...
0
votes
0answers
21 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
75 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 ...
2
votes
2answers
57 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 ...
0
votes
0answers
62 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: ...
0
votes
2answers
32 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 ...
1
vote
0answers
32 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 ...
7
votes
3answers
428 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
76 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 ...
8
votes
1answer
120 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 ...
0
votes
0answers
299 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 ...
5
votes
1answer
738 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
377 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 ...
1
vote
1answer
17 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 ...
0
votes
2answers
397 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 ...
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
47 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
1answer
35 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 ...
0
votes
3answers
345 views

Proper way to upgrade Oracle database

Two questions: I have 11.2.0.3 database. I need to upgrade to a higher version either 11.2.0.4 or 12.1.0.2. Which one I should upgrade it to? Im not going to upgrade on the same server. I will have ...
2
votes
4answers
234 views

Upgrade scenario: Oracle 8.0.5.0.0 to Oracle 12c?

we have a very old Oracle 8.0.5.0.0 database here that - unfortunately - is still used heavily as every day production system. I want to start making plans on how to get this DB upgrade to a recent ...
1
vote
1answer
86 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
1answer
98 views

MySQL percona 5.6 to MySQL 5.5 replication

Scenario 1 I am having a MySQL DB on 5.5 which is compliance, So need to upgrade it to MySQL 5.6. while doing this we see that 5.6 is running slow, were as it runs perfectly on 5.5 backup. Scenario ...
0
votes
0answers
81 views

Oracle database doesn't go to upgrade mode

I am trying to upgrade/migrate from 10g to 11g. When I start the database in upgrade mode with: startup upgrade select status from v$instance STATUS -------- MOUNTED It doesn't go to upgrade ...
0
votes
1answer
185 views

Forgot to run END_UPGRADE during a Timezone File Upgrade (ORA-56924)

I ran the following to upgrade my timezone file from 4 to 14. The issue was after running the upgrade I forgot to run DBMS_DST.END_UPGRADE and put the DB back up and enabled incoming connections. ...
0
votes
0answers
29 views

Upgrade MongoDB cluster from 2.4.10 to 3.0.4

I have a MongoDB cluster running on 2.4.10 in production. According to the MongoDB docs, I have to do a step upgrade: from 2.4.10 -> 2.6 -> 3.0.4 For rollback we have to do step rollback: from ...
2
votes
0answers
17 views

How do I quickly tell the structural differences between two databases? [duplicate]

I am upgrading a web application to a newer version and need to migrate the data manually. The newer version uses slightly different database structure. It has added a few tables, but all of the old ...
1
vote
1answer
103 views

MongoDB Upgrade to 3.0: HostAndPort Exception

I want to upgrade my small MongoDB-Cluster (1 mongos, 3 config-servers, 2 shards a 3 nodes) running on OpenSuSe 13.1 (64bit) from 2.6.7 to 3.0.5. But it fails at the second step of the upgrade guide: ...
2
votes
0answers
29 views

Upgrading SQL database resulting error [closed]

I've currently updated my SQL environment and moved everything over to a new database. This includes the BizTalk service we are using. However, when I retired my old database, I started to received ...
2
votes
1answer
2k views

Set sql_mode “blank” after upgrading to MySQL 5.6

After upgrading MySQL from 5.5 to 5.6, some our app face to problem and need set sql_mode to blank to solve this issue. I added sql_mode = '' to my.cnf but there was no effect on the mysql setting. ...
3
votes
3answers
163 views

Restoring and upgrading multiple databases

I have a SQL Server 2005 instance on my PROD server. I have been given a task to migrate databases from that instance to a different box (SQL Server 2008 R2 on Windows 2008 R2). The current instance ...
2
votes
1answer
109 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 ...
1
vote
1answer
2k views

Oracle 11.2.0.3 to 11.2.0.4

I'm planning to upgrade 3 instances of Oracle (all same Oracle Home) from 11.2.0.3 to 11.2.0.4. I'm going through the installer and I get to the question about Upgrade or install just the database ...
2
votes
0answers
79 views

No significant performance increase after migrating from SQL Server 2005 32bit 4 Cores 4 GB RAM to SQL Server 2012 64bit 4 Cores 32 GB RAM [closed]

We run regularly a series of data analysis scripts on one of our databases. The MDF File of the database is several gigabytes big, the scripts perform not only selects, but also inserts, updates and ...
5
votes
1answer
941 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 ...
-2
votes
1answer
281 views

Moving from Oracle 11.2.0.1 to 11.2.0.3

We are going to upgrade our database soon from Oracle 11.2.0.1 to 11.2.0.3 We have our customer relation application that runs on the Oracle background. Both Oracle and the company that designed the ...
0
votes
1answer
127 views

Do I need to rebuild indexes when upgrading a DB from 2008 to 2012?

I can't find anything on BOL that indicates I need to rebuild indexes or statistics after the migration and compatibility level upgrade of a database. But I have read a few articles/answers around the ...
2
votes
3answers
199 views

“No database selected” or “Table 'DB.table' doesn't exist” failures in pt-upgrade run where queries from multiple DBs were collected with tcpdump

I collected queries on our Master using the following tcpdump command: tcpdump -i any -s 65535 -x -n -nn -q -tttt 'port 3306' > tcpdump.tcp The queries are executed amongst several databases. I ...
3
votes
0answers
185 views

Postgresql upgrade issue

I'm trying to test the Postgresql 9.3 -> 9.4 upgrade process on the development environment on windows and I get weird issue during the pg_upgrade invocation: PS D:\bin\postgres-9.4> ...
1
vote
1answer
709 views

MySQL 5.6 Slaves Fail to Reconnect to older MySQL server when it goes down for backups

I have an existing replication setup with Masters and Slaves running MySQL 5.0. A long existing script runs at night which restarts MySQL on the master with skip-networking, runs a backup, and then ...
0
votes
1answer
50 views

A question about oracle upgrade from 12.0.0.1 to 12.0.0.2 using dbua

I found this guide for upgrade. After the upgrade, can I delete safely the old DB product dir /var/oracle/app/oracle/product/12.1.0 ?
1
vote
1answer
94 views

Unknown sticky Problem after MySQL upgrade

few weeks ago we upgraded mysql server from 5.5 to 5.6 on 1st server few days ago (5May) I reboot mysql server , after this customer reported that some database data table not load to their site . ...
0
votes
1answer
533 views

Cannot select features to install from SQL Server 2005 SP4 installation process [closed]

The issue: I cannot select MSSQLSERVER from the feature list I want to update as part of the SQL Server 2005 x64 Service Pack 4 installation process. Please note exe file is being raised from C:\ ...
0
votes
2answers
59 views

Shall i upgrade Database server from 2005 to 2012 without upgrading SSRS or web Application

Shall i upgrade Database server from 2005 to 2012 without upgrading SSRS or web Application relying upon the database? Will the SSRS reports and Web application continue to work? Would be appreciated ...
1
vote
1answer
54 views

MySQL 5.6 upgrade - reducing code changes / developer burden

Does anyone know the key things that should be done when moving to MySQL 5.6 to reduce the amount of code changes required? I found that new installations of it have STRICT_TRANS_TABLES set for ...
4
votes
2answers
9k 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
107 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
0answers
46 views

The same timestamp in different MySQL versions

I read in mysql 5.6 SQL changes following text: TIMESTAMP columns not explicitly declared with the NULL attribute are assigned the NOT NULL attribute. (Columns of other data types, if not ...