SSMA. Connect to Azure SQL Database Managed Instance to migrate from MySQL to Azure SQL
I just started using SSMA with the aim to migrate data from a MySQL server to my own Azure SQL database to work with the data in an Azure Logic app, which does not support MySQL very well. My idea is to run the an SSIS package to migrate data between the MySQL and SQL Azure Servers on a regular basis.
However I'm struggling connecting to the Azure SQL from SSMA. See below. I've given the user db_owner, ddl_admin, db_datareader and db_datawriter but still get this error. I can login with the user in SSMS without any issues to add tables, etc. What could be wrong? I am expecting to see a few test tables
EXEC sp_addrolemember N'db_owner', N'mysq...'
GO
EXEC sp_addrolemember N'db_datareader', N'mysq...'
GO
EXEC sp_addrolemember N'db_datawriter', N'mysq...'
GO
EXEC sp_addrolemember N'db_ddladmin', N'mysq...'
GO
So I got the connection bits working by changing project type in the new project dialogue. There are two different SQL Azure project types and I had selected the wrong one. See here SQL Migration Assistant for MySQL
- Laravel query builder using 'whereNotIn' throws error
- MYSQL - count number of rows in each table
- Cannot delete or update a parent row: a foreign key constraint fails
- Condensing a query into a single better formatted query
- Redact the column in a SELECT clause depending on a condition using CodeIgniter's active record
- get images list according to there message and thread id from database
- Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates
- how to convert mysqli_set_charset($conn,"utf8") into PDO format in MYSQL?
- MySQL, join to find only max transaction count based of group
- is `date` a valid mysql column name?
- CodeIgniter SELECT query with JOIN conditions using FIND_IN_SET() is not returning the expected results
- How to only append a wildcard at the end of a WHERE LIKE condition with CodeIgniter's active record
- How to separate logic in a Codeigniter active record WHERE clause
- Does the JDBC specification define what happens if you call ResultSet.getObject(String) for a query which has conflicting column names?
- Chronologically order a SELECT query's results by month name
- Calculate tiered discount amount using a CodeIgniter query
- Join query with comma separated values in codeigniter
- duplicate entry error in mysql - codeigniter
- What is an elegant way to deal with several optional filters?
- #1130 - Host 'localhost' is not allowed to connect to this MySQL server - After running an Acunetix scan
- Detect mysql update/insertion failure due to violated unique constraint
- Duplicate table entry error
- Catch duplicate key insert exception
- How to catch error 1062 "duplicate entry" independent from used database/engine?
- #1062 - Duplicate entry for key PRIMARY
- How to Redirect user to some other page if Duplicate Entry Error Occurs?
- check for duplicate entry vs use PDO errorInfo result
- How to handle error for duplicate entries?
- Dealing with duplicate keys in codeigniter mysql insert
- Codeigniter - Model - Duplicate Entry Alert