Post reply

Clustered Index In Azur

  • 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

     

  • 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.

  • 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.

  • October 31, 2020 at 10:42 am

    This was removed by the editor as SPAM

  • May 21, 2021 at 6:25 pm

    This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply