= 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; }}}