SQL Server Upgrade 2008R2 to 2019

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
teschste
Posts: 14
Joined: Thu Aug 29, 2013 7:34 am

SQL Server Upgrade 2008R2 to 2019

Post by teschste » Fri Apr 29, 2022 11:31 am

We are planning on migrating our SQL Server database from 2008R2 to 2019. I know 2019 can maintain compatibility with 2008R2 but that is basically kicking the can down the road until a future version comes out that no longer supports that compatibility, so I have two questions:

1. What do you recommend to best support upgrading the database for future compatibility?
2. Are there any plans to support alternate databases in the future, such as PostgreSQL?

Thanks!

Tonya
Posts: 862
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: SQL Server Upgrade 2008R2 to 2019

Post by Tonya » Sun May 01, 2022 6:55 am

Hello,

Thank you for reaching out in regards to your concerns. We typically recommend upgrading to the latest versions but if that's not possible, SQL Server 2019 is supported on Vault 10.x. As of right now, we have no plans of supporting different database alternatives.

Thanks,

Tonya

teschste
Posts: 14
Joined: Thu Aug 29, 2013 7:34 am

Re: SQL Server Upgrade 2008R2 to 2019

Post by teschste » Mon May 02, 2022 7:37 am

Thank you for that but apparently I did not make my primary concern clear.

We are on Vault 10 already but when we upgrade from SQL Server 2008R2 to 2019, will there be any issues if I do not put the database in compatibility mode?

I presume from your previous response that there will not be but I want to be certain.

Thanks!

Tonya
Posts: 862
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: SQL Server Upgrade 2008R2 to 2019

Post by Tonya » Mon May 02, 2022 7:59 am

Hello again,

We are not aware of any negative effects to the Vault application that would be caused by changing the compatibility mode of the sgmaster and sgvault databases, but there could be some SQL related item that makes a difference.

Tonya

teschste
Posts: 14
Joined: Thu Aug 29, 2013 7:34 am

Re: SQL Server Upgrade 2008R2 to 2019

Post by teschste » Mon May 02, 2022 8:26 am

One more question, I find that SQL Server 2019 can be installed and run on Linux. Can Vault Standard 10 successfully connect to and run using the Linux version of SQL Server?

Tonya
Posts: 862
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: SQL Server Upgrade 2008R2 to 2019

Post by Tonya » Mon May 02, 2022 9:20 am

No, the Vault Server Database requires a Microsoft SQL Server.

Thanks,

Tonya

Post Reply