How to upgrade database with upgrade.sql

i have nopcommerece v2.40 installed & working fine on online server
i have so many clients & data on my database, now i want to use v2.5
how can use upgrade.sql to update my database.

Mobile Doctor wrote:

Best way is the use the SQL management studio to up update the db.  Always make a backup before doing any upgrade.

I have install mu mssql database on hosting server
pls clear it to install SQL management studio is on my pc or on hosting server

Mobile Doctor wrote:

The SQL Mnagement Sudio must be installed on your PC. You have actually 2 ways of updating your database -- remotely and via your PC.

To update your database remotely do the following:
1.) Activate 'Store Closed' using nopCommerce Admin page.
2.) Connect to the SQL Server on your hosting server via SQL Management and run the upgrade scripts sequentially until your reach the latest version.
3.) Don't forget to deactivate 'Store Closed' using Admin page after uploading the latest version of nopCommerce.

To update your database on your PC, do the following:
1.) Activate 'Store Closed' using Admin page.
1.) Backup your database in your hosting server.
2.) Restore the database in your PC with a MS SQL Server installed (you may download the MS SQL Server Developer Edition for Free from Microsoft if you don't have a license).
3.) Connect to your MS SQL Server installed on your PC using SQL Management Studio.
4.) Run the upgrade scripts sequentially until you reach the latest version.
5.) Backup the upgraded database in your PC.
6.) Restore the updgraded database to your hosting server.
7.) Don't forget to deactivate 'Store Closed' using Admin page after uploading the latest version of nopCommerce.

Thanks for ur reply
1. i download SQL Management Studio on my pc & run it.
2. select remote database (on my hosting)
3.  select quiry analysis & double click upgrade.sql file
4. Upgrade Sucessfull everything ok

Mobile Doctor wrote:

Glad you were able to upgrade without any hitches.