Forum Discussion

Musadev's avatar
Musadev
Resolver III
2 years ago
Solved

Microsoft Fabric

Can we migrate local MySQL/SQL DB server to Fabric?

By migration i mean to clone the entire Database.

  • Unfortunately based on my understanding Fabric as of today doesn't support lift and shift of any database directly . Also the fabric warehouse is not exactly compliant with all sql aspects. 

    • A work around might be to migrate the sql server to azure sql database and then use the mirroring concept

2 Replies

  • Unfortunately based on my understanding Fabric as of today doesn't support lift and shift of any database directly . Also the fabric warehouse is not exactly compliant with all sql aspects. 

    • A work around might be to migrate the sql server to azure sql database and then use the mirroring concept
  • Lucas_Zani's avatar
    Lucas_Zani
    Regular Visitor

    Ao tentar executar uma atualização do PowerBI por meio do Fabric, a seguinte mensagem de erro aparece: Falha ao atualizar dados da fonte de dados: 'Ocorreu um ou mais erros'.

    Você poderia me dizer como corrigir esse erro? Os dados que estou tentando carregar estão no MySQL e o Gateway está atualizado.