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.

Accessing Databases

Interestingly enough, you must connect to a specific database the way I have them setup (server-less). That means that you must input both your username and password on the first page, and the database name on the second page.

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;