Differences between revisions 1 and 2
 ⇤ ← Revision 1 as of 2022-06-07 14:17:53 → Size: 439 Editor: scot Comment: ← Revision 2 as of 2022-06-07 23:37:06 → ⇥ Size: 698 Editor: scot Comment: Deletions are marked like this. Additions are marked like this. Line 6: Line 6: == 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.

# 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;