92
Really Short Answer - In Place is okay. You can review your configuration afterwards and implement the best practices for SQL Server 2012.
A Longer Answer on SQL Server Upgrades/Migrations
So this is an opinion thing and there isn't a necessarily wrong or right answer but I prefer migration style upgrades over in-place for a lot of reasons. That being said ...
35
There are a lot of reasons to consider an upgrade to SQL Server 2016. Most of the time, these reasons vary depending on the version of SQL Server one is coming from. This won't be an exhaustive list, but I'll give a few reasons that come to mind. Including one very big reason we just learned about with SQL Server 2016 SP1's release in November of 2016. ...
25
I hacked the problem by running (as root):
mv /usr/bin/pg_ctl{,-orig}
echo '#!/bin/bash' > /usr/bin/pg_ctl
echo '"$0"-orig "${@/unix_socket_directory/unix_socket_directories}"' >>
/usr/bin/pg_ctl
chmod +x /usr/bin/pg_ctl
Run pg_upgrade as intended, then undo the hack:
mv -f /usr/bin/pg_ctl{-orig,}
The problem is that pg_upgrade executes ...
answered Dec 24 '14 at 1:28
Ziggy Crueltyfree Zeitgeister
4,4381 gold badge10 silver badges20 bronze badges
25
This is how I solved my problem.
Upgrade Postgresql 8.4 to 9.4 in Centos
1. Yum Install PG9.4
2. wget http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm
3. yum install pgdg-redhat94-9.4-1.noarch.rpm
4. yum install postgresql94-server
5. service postgresql-9.4 initdb
6. chkconfig postgresql-9.4 on
Backup Data
7. su - ...
15
I found a workaround!
Stop your db. Then start it with:
mysqld --skip-grant-tables &
And then, I could finally do my upgrade:
mysql_upgrade
14
In my experience, the same decision making process should be made as prior. AFAIK there hasn't been any 'world changers' with SQL Server installation, within the MS SQL Server product in itself, and the potential problems you have when rolling out software with millions of lines of code. Something bad could happen and now you're stuck with no 'ROLLBACK' ...
14
Given that you work for a company that is using Enterprise Edition I'm going to assume you aren't touching one of their servers. If you are please don't. As mentioned in the comments this could be a very expensive mistake and if the work you are doing is on any company asset please contact the company's DBA. That's what they are there for.
That said, let ...
12
Oracle 8.x.x has been out of support for some time.
Apologies for the bad news, but your only option is to either recover the software from the dead disk, or ask Oracle (obviously with a valid support contract) for a copy of the software. Raise a ticket on My Oracle Support and they will help you.
12
After many attempts to fix this problem, this command finally worked for me:
export LC_CTYPE=en_US.UTF-8 export LC_ALL=en_US.UTF-8
12
Problem resolved by adding an alias to the instance in the SQL Server Agent Configuration.
The alias was defined using the fully qualified domain name of the server. Example:servername.domain.biz\instance_name otherwise the agent will still error out and shutdown.
Also, the Agent was disabled in sp_configure
sp_configure 'Agent XPs', 1
go
reconfigure ...
10
I would slipstream Service Pack 2 (and perhaps Cumulative Update 2 as well) into the R2 installer prior to running the upgrade, especially if you have enabled the extended partition support. This guide walks you through slipstreaming (it talks about a different service pack and CU, but the process is the same). Slipstreaming will save you a bunch of time and ...
10
Typically the features that you don't hear about from marketing are the ones that don't bring in all the money (e.g. pushed as "enterprise feaures" in order to sell Enterprise Edition). I answered a similar question here that provided a list of my favorite new features in 2012, that also aren't limited to Enterprise Edition:
What are Objective Business ...
10
After poking around in SSMS for a while I noticed that on the secondary replica there was a pause icon next to the Availability Databases. The primary had shown both were "green", but there was an option on the secondary to Resume Data Movement. I resumed the first database, and immediately the In Recovery status message was removed. A minute later it ...
10
That's a really big question so let's break it up a bit.
What can I do in advance?
Start with some required reading.
2008 R2 Backwards Compatibility
2008 Backwards Compatibility
These links have links to further information such as
Deprecated SQL Server Features
Discontinued SQL Server Features
Breaking Changes
Behavior Changes to SQL Server Features
...
10
So my question here is not how, rather will like to know the risk involved or any pre-checks that can be done before planning this upgrade?
You should run upgrade advisor and address the issues reported by it before migrating.
Refer to my answer for an extensive list of pre and post upgrade steps.
SQL server which needs to be upgraded from version 2005 ...
8
On Windows, simply stopping the postgresql service, then running postgresql-9.3.1-1-windows-x64.exe on top of the existing 9.3.0 works. No uninstall necessary. Of course, a backup is recommended.
Clear, explicit documentation for the update procedure on Windows is absent. Note that the documentation link provided by @dezso has been moved in the current ...
8
This answer applies to modifying the PostgreSQL source code by applying a "diff" or "patch". It's not about installing minor version updates; to do that, just download and run the installer.
To alter the PostgreSQL server its self or its procedural language runtimes, you will generally need to recompile PostgreSQL from scratch.
On Windows that's a bit of a ...
7
I tend to follow the following rule for existing code-base:
If it's working fine, there is no need to upgrade unless there's a specific feature you are missing.
InnoDB does get some nice performance boosts in 5.5, but if your current use-case is not seeing any issues with your install, why upgrade?
If you ran some performance tests on a development ...
7
You need to get away from MySQL 5.1 ASAP
MySQL 5.0 Active Support ended on December 31, 2009 - Now in Extended Support Phase
Per the MySQL Support Lifecycle policy, active support for MySQL 5.0 ended on December 31, 2009. MySQL 5.0 is now in the Extended support phase.
Versions have changed rapidly since Oracle stepped in
MySQL 5.1.61 released 2012-01-11
...
7
Given step 9 in the link you provided:
9.Run pg_upgrade ... Obviously, no one should be accessing the clusters during the upgrade. pg_upgrade defaults to running servers
on port 50432 (sic) to avoid unintended client connections. You can
use the same port numbers for both clusters because the old and new
clusters will not be running at the same ...
7
Even if you install SQL Server 2012 clean, you get menu items in the start menu under SQL Server 2008 (e.g. Configuration Tools > Installation Center). In Add/Remove Programs do you see anything other than 2008 R2 Management Objects and 2008 Setup Support Files? I think these get installed by 2012 setup for backward compatibility reasons.
To be on the safe ...
7
The no-beep option causes the mysql command line client not to beep when errors occur.
If that's an option you want, it should be in the [mysql] section of your my.cnf. This error suggests that it's in the [client] section of your my.cnf, which causes mysql_upgrade to throw the error since the option isn't recognized.
Check your my.cnf and either remove ...
7
No, it shouldn't prevent the table from being altered. Though, if you drop the underlying table a view depends on, or alter/remove the columns from the table the view uses, the view can become invalid. You can check what views are invalid in your system with the following query:
sql> select name from dba_objects where object_type = 'VIEW' and status = '...
7
Why should I upgrade ?
For MySQL 5.1.37 and prior, InnoDB does not take advantage of multiple CPUs/multiple cores. No amount of scaling up of hardware will ever make InnoDB go any faster. MySQL 5.1.38 first introduced the InnoDB Plugin which has many aspects of tuning now available for multiple CPU/multiple core engagement. This is now fully available as ...
7
The problem was that our new RDS instance was being throttled on writeIOPS, we could see queued disk operations (DiskQueueDepth of 10 or greater) and we could see writeIOPS averaging 300, whereas Amazon only provide 100 reliable iOPS (source).
The solution was to fork out approx $200 per month for "provisioned iOPS". 1000 is the smallest you could buy (...
7
The short answer is yes, much the same as when you mirror from a lower version to a higher version. Make sure you do not have the 2016 as readable so it's not trying to upgrade the database version. That said I haven't tried this, just going on how log shipping/mirroring work.
If it works it is only supported doing this as a means to upgrade, leaving 2014 ...
7
The ideal situation is to have a server that, in terms of OS and other software, exactly matches the production environment, upon which you can perform the update first. That way you know everything that is required.
This would preferably be a VM that you could snapshot, so if you encounter and fix a problem you can revert to the snapshot and start again ...
7
Yes, you can upgrade directly to Service Pack 3. Service packs are cumulative; SP3 contains everything in SP2 and SP1.
This has always been true for every version of SQL Server I’ve worked with, and I'm old. But for those needing to read this from MS documentation on their web site instead of peers answering questions here, here is one official source:
...
6
Yes, according to Supported Version and Edition Upgrades you can upgrade in place from 2005 Standard to 2012 Enterprise, provided SQL Server 2005 is currently on an operating system supported by SQL Server 2012 Enterprise (meaning forget about XP or 2003 RTM) and that the architecture is the same (e.g. 64-bit -> 64-bit).
Though you should do step 1 and 2 ...
Only top voted, non community-wiki answers of a minimum length are eligible
