= 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:

{{{#!highlight sql
CREATE LOGIN student WITH PASSWORD = 'CPTR319_2023' 
CREATE USER student FOR LOGIN student;
ALTER ROLE db_datareader ADD MEMBER student;
}}}