This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 43%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Hi,
I need to migrate the SQL2012 (on Win2012R2) to a new server with SQL2022 (on Win2022). As there are some program issues, I need to rename the SQL2022 to use SQL2012 hostname.
Can I just Detach and Attach the database from old server to new server?
If not, can I just use the GUI to backup/restore the database instead of use T-SQL statement?
Thanks
Best Regards
Chong
to a new server with SQL2022
Do you want to use SSRS 2022 as well? The versions 2012/2022 are very different and it requires more then moving some databases.
yes. I will use the SSRS 2022 also.
Can you share more information on “requires more then moving databases”?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Chong
Did these answers help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers.
Best regards,
Aniya
Hi Chong,
I recommend you to follow below link to migrate SSRS
Moving Report Server Databases to Another Computer (SSRS Native Mode)
Regards
Javier
I read this already. My capture paragraph is captured from this link…..
My server can take offline, but I am not sure if detach and attach method can be use if the SQL server version change from 2012 to 2022.
Yes, you can attach SQL 2012 database files to SQL 2022. Also use Backup restore (which is the way I prefer)
Regards
Javier
Thanks. Then I may use the backup restore approach.
Can I use the GUI backup instead of using T-SQL?
Yes. you can use both T-SQL or SSMS to backup/restore
Hi @Chong
According to the document "Backup and Restore Operations for Reporting Services":
Because a report server is a stateless server, all application data is stored in the reportserver and reportservertempdb databases that run on an SQL Server Database Engine instance. You can back up the reportserver and reportservertempdb databases using one of the supported methods for backing up SQL Server databases.
If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.
Best regards,
Aniya
Hi @Chong
Has your issue been resolved? Please checking in to see if the below suggestions helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Best regards,
Aniya
yes. I will use the SSRS 2022 also
As I wrote the versions are very different and not with a simple moving of the RS database done. The migration process is more a complete new installation, see Upgrade and Migrate Reporting Services
"Upgrade to Reporting Services 2017 and later from Reporting Services 2016 and older isn't the same upgrade scenario as in previous versions."