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:
Toggle line numbers
1 CREATE LOGIN student WITH PASSWORD = 'CPTR319_2023'
2 CREATE USER student FOR LOGIN student;
3 ALTER ROLE db_datareader ADD MEMBER student;