cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

MS SQL upgrade method

rhart
16-Pearl

MS SQL upgrade method

When upgrading the MS SQL Server from 2014 to 2017, is it possible to backup the existing SQL server and then restore the backup to the new SQL server, which is on a new VM. Does PTC provide any guidance, I couldn't find it.

Apart from upgrade-in-place, are there other methods to update the database.

Our Database Administrator doesn't see any reason it wouldn't work, but we wondered what method other people used.

ACCEPTED SOLUTION

Accepted Solutions
HelesicPetr
22-Sapphire I
(To:rhart)

Hi @rhart 

It is common process. Export database in earlier version and then import it to a new version database.

You can read for example Upgrade guide for Windchill. 

Every Windchill upgrade contains that process. 

 

Usually restore a backup in a new version is supported by MS SQL Database. 

MS Link

HelesicPetr_0-1646140017773.png

 

PetrH

 

View solution in original post

2 REPLIES 2
HelesicPetr
22-Sapphire I
(To:rhart)

Hi @rhart 

It is common process. Export database in earlier version and then import it to a new version database.

You can read for example Upgrade guide for Windchill. 

Every Windchill upgrade contains that process. 

 

Usually restore a backup in a new version is supported by MS SQL Database. 

MS Link

HelesicPetr_0-1646140017773.png

 

PetrH

 

Exactly the answer I was looking for, perfect thank you very much

Announcements


Top Tags