How restore Backup of Sql DataBase from SQL Server 2014 to SQL Server 2022 ???

I have bought a new Windows VPS for testing and now have installed nopCommerce 4.80.3 (runs on SQL Server 2022)

I have upgraded my nopCommerce on the old VPS to version 4.80.3 (runs on SQL Server 2014)

Both versions are the same and running well

Now I want to have a copy of older DB from old SQL Server 2014 to newer version SQL Server 2022

How can I do it?

You can back up and restore it using the SSMS. Please check https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver16&tabs=ssms

sanju.dahal741 wrote:

I am still not able to do this... Any other ways?

RE: "still not able to do this."
Please clarify.  Are you getting an error message?

As per instruction "Select Add and navigate to where your .bak file is located. Select the .bak file and then select OK.", note that the the .bak file must be accessible to the SQL Server instance, not just your local machine running SSMS.  If SQL Server is running on a different machine, the file must be on a drive that the server can access, such as a local drive on the server or a network share with proper permissions.

Copy the .bak file to a location on the SQL Server.

danielaguero wrote:

Very simple. Install SQL management studio, connect to the old database server. Backup the database using backup option. Connect to the new server, restore the database there.
If you are unsure let me know, I would be happy to help.