How to update the database?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
6 years ago
I have a database_xxx.bak file of version 3,9.
And I downloaded the upgrade.sql file.
What with them to do? I read: "Once an upgrade script is downloaded, execute it over your database." How?
6 years ago
trofimovda wrote:
I have a database_xxx.bak file of version 3,9.
And I downloaded the upgrade.sql file.
What with them to do? I read: "Once an upgrade script is downloaded, execute it over your database." How?

Hi.
... you can do it with Microsoft SQL Server Management Studio (only :)
Best Regards.
6 years ago
I am having some difficulty with my Upgrades because I am running nop under Windows Server 2016 Core, so I have no GUI.

I am suing MS SQLEXPRESS and here is the command line that I am using to upgrade
sqmlcmd -U username -S compname\sqlver -d databasename -i upgrade.sql

Optionally you can add -o outputfile.txt to send the output to a file for evaluation.
You could also do -P Password, but I prefer to type it in myself

You can get the username, password, compname\sqlver, databasename, and Password from settings.txt in the App_Data folder
6 years ago
Hello Everyone,

My technical knowledge is quite limited on how to setup the hosting or configure settings. I never setup an SQL dB on an hosting. My basic knowledge is to go to the FTP upload the files to the relevant location and publish the site.

All I need to know is how to transfer my store from "A" hosting to Azure. If you can give me a step by step explanation with even simple bullet points that would be really great.

Really need your help!

Thank you very much
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.