How do I migrate the DB to Azure SQL and get admin rights

[support@heens-it.be]

Hi,

First question
I've setup a Azure SQL and created a new envirnment with a new empty DB.
Then I exported the "old" database and imported it into the Azure DB.
But when I restart the application and log in into Azure All menu items are grey and I can't see any connections or credentials...
What am I doing wrong?

And second question
Is there a way to login with and Azure Active Directory user into the database?
I can login that way via the SQL Server Management Studio (version 17.9.1) but not with aSG, is that a feature that needs to be requested or am I (also here) doing something wrong?

Filip Heens

[DevOma]

You should not export and import the data to transfer it to AZURE - there are some tools to transfer "local" databases to a AZURE environment - please you these tools instead - then you should be able to use it like your old database... If you do not have access to the same ActiveDirectory you should switch the login user to a username / password combination and after successfully working on AZURE you can switch back to AD

Azure AD accounts could not login to AZURE DB - that was my last stand. I have to check that...

[support@heens-it.be]

You should not export and import the data to transfer it to AZURE - there are some tools to transfer "local" databases to a AZURE environment - please you these tools instead - then you should be able to use it like your old database... If you do not have access to the same ActiveDirectory you should switch the login user to a username / password combination and after successfully working on AZURE you can switch back to AD

Azure AD accounts could not login to AZURE DB - that was my last stand. I have to check that...

Hi Olivier, 
thanks for the quick answer...
migrating with the SQL tools (Data Migration Assistant), gave some errors about joins etc... that's why I did the export/import...
errors are
Object dbo.ItemProperties.Data uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 5, Column 5.
Object dbo.Items.Description uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 10, Column 5.
Object dbo.Logs.Details uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 9, Column 5.
Object [dbo].[SecurityGroupAssignmentsForAllItemsGet] uses the old style join syntax which can have poor performance at database compatibility level 90 and higher. For more details, please see: Line 3, Column 10.

The element User: [HEENSIT\ASG Users] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
The element User: [HEENSIT\Domain Admins] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
The element User: [HEENSIT\gert.starckx] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.

do I do the switch to usersname / password before the migration or is there a way to do it after the migration?
And changing the login type in patch 7.1 crashed… when doing it it with an earlier version I lost all my private logins? How do we keep those?

[DevOma]

Ok - let me first check the "Switch login type" with patch 7.1 - you only need it if you can't use your AD-Account anymore - I do not know that - as I told you some weeks ago there was a warning at some MS sites that AZURE AD-Accounts can't connect to AZURE-DB

[support@heens-it.be]

Ok - let me first check the "Switch login type" with patch 7.1 - you only need it if you can't use your AD-Account anymore - I do not know that - as I told you some weeks ago there was a warning at some MS sites that AZURE AD-Accounts can't connect to AZURE-DB

Ok tnx,
for the Azure -DB, I can connect with the AD account when using SQL Server Management Studio...
With the SSMS and the DMA normally I can migrate the data and schema or should I first create the Azure-DB via de ASG application and then only migrate the data?
BTW the Azure AD account isn't the same as the AD-Account name, emailadres is the same, but the two domains aren't synced...

[DevOma]

I fixed the issue with "Change Login Type" - if you really need it let me know we can provide privates fixes for such cases

Try to migrate schema and data - that should work.

[support@heens-it.be]

I fixed the issue with "Change Login Type" - if you really need it let me know we can provide privates fixes for such cases

Try to migrate schema and data - that should work.

Hi Olivier,
I did it anyother way, but it worked (for a part at least…)
I created a new database via ASG, then emptied the tables and then copied the data via the DMA tool...
I can now log in, but not if the pc isn't booted into the domain.
So I want to try it with changing the logintype... if you could provide the update, please do so, otherwise I wait until the next public available one...

Filip

[DevOma]

Too many changes that are not tested - so you should wait or install Patch5 again (just for changing login type) - I think the error is since Patch6