Best way to change collation?


  • Hi,

    I know this is not supported by Azure. But I have think this can be done.

    1. Backup database

    2. Restore database locally

    3. Using script to change collation

    4. Backup database

    5. Restore to Azure.

    It´s not quite easy or fast or good solution but is possible. Is there any other solution for this? Maybe ticket to Azure support to do this? But I need this database working from 6:00AM to 22:00PM because is prod database. Only possibility is do this over night.

    marți, 12 iunie 2018 13:34