April 4, 2016 at 5:18 am
We are planning to migrate an on-premise test db to sql azure environment(not azure VM). How can I migrate domain users to azure sql.
We already have setup the active directory replication from on-premise to cloud. We are trying to utilize the latest features of azure sql.
Many thanks!
April 4, 2016 at 8:03 am
You have to create an Azure Active Directory service in your Azure account and then federate that with your local Active Directory. AD in Azure SQL DB is in preview mode. That means it's available, but might not necessarily be fully functional. There are additional changes you have to make to your Azure SQL Database server instance as well in order to enable the AD connections. You can read about it here[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 4, 2018 at 6:58 am
This was removed by the editor as SPAM
September 4, 2018 at 7:20 am
Lj Burrows - Tuesday, September 4, 2018 6:58 AMYou can migrate SQL Server Database to Azure SQL Database by Generating script, copy database wizard, Import / Export Data tier application , using DMA. Here are the step by step process to move SQL database to Azure SQL database. It also covers an quick approach to migrate SQL data to Azure database:
https://www.sqlserverlogexplorer.com/transfer-sql-database-azure/
How does that migrate the domain and server level logins?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply