Moving Passwordstate to Azure

[support]

Below is some information Click Studio provide to customers when they request some information on moving Passwordstate to an Azure environment:

 

If you intend to move to the cloud, please ensure you keep your current on premise version running, and only shut that down once you have confirmed that you can successfully access your new instance in Azure.

 

The first thing you’ll need to do is determine which kind of database you’ll be using in Azure.  You can either install SQL on a Azure Windows Server (just as you would on an On-Premise server), and move your database to it following this document: https://www.clickstudios.com.au/documentation/move-new-database-server.aspx

 

 

If you prefer to use an Azure SQL database, please use Microsoft documentation to help with this migration.  We haven't fully documented this ourselves but if you install the latest build of SQL Management Studio Tools, there is an option to migrate data from your local SQL database directly to a Azure SQL database.  Obviously an empty Azure database will need to be created prior to performing this migration:

 

 

After migrating your data up to the SQL Azure database, you will need to run these SQL commands when connected to it with SQL Management Studio Tools.  This will create the "Passwordstate_User" account and assign it the appropriate permissions. Azure does not allow for the USE statement, so we need to right Click Master Database and select New Query.  Execute the following script:

 

CREATE LOGIN passwordstate_user WITH password='Welcome01'

GO

CREATE USER passwordstate_user FOR LOGIN passwordstate_user WITH DEFAULT_SCHEMA=[dbo]

GO

 

 

Next right click your Passwordstate database, select New Query and run this script:

 

CREATE USER passwordstate_user FOR LOGIN passwordstate_user WITH DEFAULT_SCHEMA=[dbo]

GO

EXEC sp_addrolemember 'db_owner', 'passwordstate_user';

GO

 

 

Once you database is moved, you can then use this document to move your Passwordstate website to your Azure Windows server:  https://www.clickstudios.com.au/documentation/move-new-web-server.aspx

 

Please note you’ll need to have an external DNS entry which directs all traffic to your Azure web server, and you’ll also need to open a port on your Azure web server firewall to all access for all users. 

 

Regards,

Support