Azure Database Issues and Solutions

Importing a Database with all its data

The first thing we need to solve is getting our databases up to the cloud.

Permissions

There is no fancy GUI for the Azure SQL Database, so we have to do things like: 

   1 CREATE LOGIN student WITH PASSWORD = 'CPTR319_2023' 
   2 CREATE USER student FOR LOGIN student;
   3 ALTER ROLE db_datareader ADD MEMBER student;