Clustered Index In Azur

• arvind.patil 98284

  SSC-Addicted

  Points: 410

  More actions

  May 7, 2020 at 4:21 pm

  #3749698

  Hi Experts :-

  We are currently working on sql server 2012 and planning to migrate to Azure. I have few queries regarding azure sql.

  1. • In SQL Azure, all tables should have a clustered index.  Is this limitation removed in current version of Azure sql.
  2. What are different version available in Azure SQl.(Like for sql server we have sql server 2012, 2014 etc.)
  3. Is Table partitioning not available in Azure.
  4. Can you guys suggest some good online tool to run a compatibility test to run in our database for migration purp

   

• Karen Lopez @datachick

  SSC Eights!

  Points: 983

  More actions

  May 7, 2020 at 9:17 pm

  #3749780

  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.

• kcecil 47772

  Grasshopper

  Points: 17

  More actions

  June 3, 2020 at 12:54 pm

  #3760088

  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.