May 7, 2020 at 4:21 pm
Hi Experts :-
We are currently working on sql server 2012 and planning to migrate to Azure. I have few queries regarding azure sql.
May 7, 2020 at 9:17 pm
I will answer even though I'm not a guy.
The docs for SQL DB will answer your questions 1 and 3.
SQL DB doesn't have versions like that. It's a service, so you would migrate to whatever the current version a the time you provision the database.
You can use Data Migration Assistant https://docs.microsoft.com/en-us/sql/dma/dma-assesssqlonprem?view=sql-server-ver15 to help your evaluate feature compatibility between your on-prem SQL Server and the Azure SQL DB service. I'm not sure there's always a case for using it for migration ("it depends") but the compatibility analysis it does helpful.
June 3, 2020 at 12:54 pm
1.) You can have heap tables in SQL Azure.
2) You can do SELECT @@VERSION to see that it is not quite the same as what you get with on-premise servers.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy