For those of you who missed it in my last post, SQL Server 2019 CTP 2.5 was released last week. Which is the latest preview version, you can download it here.
I thought I would test upgrading SQL Server 2019
on Linux to CTP 2.5 by using the local repository I had created in a previous post. Which can be used to manage SQL Server installations on Linux servers that have no internet access.
You can read more about how to do that in detail in my previous post here.
Of course, testing this meant I had to upgrade my local repository first. Because I had a few issues doing this, I decided to improvise.
So, I made a copy of the original repository I had created previously just in case. Afterwards, I tried a couple of times to do a sync for the newer components. Eventually, I ended up deleting all the rpm files in the folder.
Following that I then issued a reposync command again to download the latest rpm files, which worked.
However, when it came to installing on the client it would not recognize the fact an upgrade was required. Which I resolved by running the createrepo command on the server again with the –update parameter.
SQL Server Management Studio
In addition, I decided to upgrade SQL Server Management Studio I had installed locally whilst testing this. Last week the General Availability (GA) release of version 18 was released, which you can download here.
Database scoped configuration
After the installation, I tested the behavior of the database scoped configuration to have online index rebuilds as the default again. Which I discussed in my previous post here.
However, I did encounter one issue with a database which I had upgraded to compat level 150. It was in suspect mode, however a restart appeared to resolve this (don’t use this as a fix in the real world).
After resolving this I was able to test all the databases again. Which had the same interesting results as in my previous post.
Now, one of the new features announced for the latest CTP is that you can now install Polybase on SQL Server on Linux. Which I have tested installing, however I have yet to test connecting to another data source.
I previously wrote a post about current SQL Server 2019 learning resources, which you can read here.
I hope you enjoyed this follow up to my previous post about local repositories. If you have any questions or comments about this post then leave a comment.