35
votes
What are Objective Reasons to Prefer SQL Server 2016 over Earlier Versions?
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, ...
- 17.9k
30
votes
pg_upgrade unrecognized configuration parameter "unix_socket_directory"
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}"' &...
- 4,808
26
votes
Accepted
How to upgrade PostgreSQL from version 8.4 to 9.4?
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 ...
- 549
18
votes
Accepted
MySQL - mysql_upgrade - Error occurred: Cannot setup server variables
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
- 411
14
votes
Accepted
SQL Server AlwaysOn database stuck in Not Synchronizing / In Recovery mode after upgrading. Error: Cannot open database '...' version 782
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 ...
- 1,003
14
votes
Accepted
Can I update my Microsoft Enterprise SQL Server?
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 ...
- 23.7k
13
votes
Accepted
Inability to query underlying table of a schema-bound view
From the documentation:
A query does not have to explicitly reference an indexed view in the FROM clause for the Query Optimizer to use the indexed view. If the query contains references to columns ...
- 70.8k
12
votes
Accepted
Upgrade PostgreSQL 9.4 to 9.5 : LC_ALL unset
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
- 490
12
votes
After Upgrade to 2016, SQL Server Agent can't connect to Instance
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\...
- 9,478
11
votes
Accepted
SQL Server 2019 performance worse than 2012... am I missing something?
I believe you have just discovered why the recommended upgrade process is to to upgrade your database, enable the Query Store, and test before increasing the database compatibility level.
Change the ...
- 40.2k
10
votes
Accepted
Risks involved in upgrading to SQL Server 2008 R2
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 ...
- 23.7k
10
votes
Risks involved in upgrading to SQL Server 2008 R2
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 ...
- 61.2k
9
votes
Accepted
SQL Server Distributed Availability Group databases not syncing after a server reboot
Please note, this is not a definitive answer but it's the best answer after chatting with Taryn.
However, the primary was showing a very different story. It was reporting that the separate AG was ...
9
votes
Accepted
Door Number 1, 2, or 3?...Security change, bug, or failed upgrade with an in-place upgrade from SQL Server 2016 to SQL Server 2019?
Door Number 1, 2, or 3:
2, with a dash of 3.
An ownership chain should prevent permission checks on a scalar UDF referenced from a view, so a user with SELECT permission on the view should not also ...
- 40.2k
8
votes
Set sql_mode “blank” after upgrading to MySQL 5.6
PROLOGUE
Someone asked the same thing of me in my organization because everyone was using MySQL 5.5. All DB servers was upgraded over the past 8 months to MySQL 5.6. Some client applications were ...
- 173k
8
votes
Accepted
Optimizing slow performance of simple SELECT query
Suspected main issues (synopsis)
You need to run ANALYZE after a major version upgrade with pg_upgrade. Table statistics are not copied. Possibly tune autovacuum settings, too.
A multicolumn index on ...
- 152k
8
votes
Accepted
SQL Server update from SP1 to SP3
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 ...
- 176k
7
votes
Slower queries after upgrade from mysql-5.5 to mysql-5.6
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 ...
- 241
7
votes
Accepted
Recommended ways to upgrade AlwaysOn AG from 2014 to 2016
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. ...
- 534
7
votes
How far to go when Validating a SQL Service Pack install?
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 ...
- 30.3k
7
votes
Accepted
After upgrade to SQL Server 2019 some stored procedures fail
This looks to be a problem with UDF inlining. As @ScottHodgin suggested, the first step is to install the latest CU to see if the problem persists. If that doesn't resolve the problem, your options ...
- 24.3k
6
votes
Accepted
Any known issues upgrading from MySQL 5.1.73 to 5.6.21?
ISSUE #1 : Upgrade Path
Your grant tables can get screwed up because you are leaping two versions instead of one.
I just helped someone a week ago because they did just that (MySQL service stops ...
- 173k
6
votes
How to do a minor upgrade of PostgreSQL on Windows, e.g. 9.3.0 to 9.3.1?
For the record, running the installer for Windows from Enterprise DB (the default, linked from the Postgres site), at least since the current version Postgres 9.4, you don't have to stop the ...
- 152k
6
votes
Accepted
MySQL 5.7 upgrade
As mentioned in the comments, it is not recommended to install any MySQL version (or anything else) that is not 'Generally Available (GA)' in production.
But whether you end up upgrading when it is ...
- 23k
6
votes
Why is my @@Version unchanged after upgrading?
I found the problem: The installer I had was just for SQL Server Management Studio, as @MarkSinkinson pointed out.
If you have this same problem, verify you have the correct installation file (not ...
- 109
6
votes
Accepted
Upgrade a database from SQL Server 2000 to SQL Server 2014
You cannot restore a SQL Server 2000 database onto a SQL Server 2014 instance. You need to restore to SQL Server 2008 or 2008 R2 instance first, then take a backup of that database which you can then ...
- 67.2k
6
votes
SQL Server 2016 in-place upgrade time for large databases
I'd really recommend not doing an in-place upgrade; certainly not for a very large system like yours. The reasons for this recommendation are many, and have been covered extensively by Mike Walsh in ...
- 67.2k
6
votes
Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
At our location, we have SSIS running on SQL Server 2012. Our databases are on SQL Server 2016. We haven't had any issues with any of them, but then again, it really depends on what your packages are ...
- 461
6
votes
SQL Server 2008 R2 Edition Upgrade Process
You will need to use SQL Server 2008 R2 Enterprise Edition media to perform the in-place edition upgrade. I am unaware of any option available that allows you to perform an edition upgrade without a ...
- 9,080
6
votes
Eliminating OIDs while upgrading PostgreSQL from 9.4 to 12
Here is a query to help find all tables that have the WITH OIDS set. It also generates the DDL to remove.
SELECT 'ALTER TABLE "' || n.nspname || '"."' || c.relname || '" SET ...
- 61
Only top scored, non community-wiki answers of a minimum length are eligible