Mobile Doctor wrote: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
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.