Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
7 months ago
Solved

Complete SQL Server database migration

I have a SQL Server database called db_info with tables, views, stored procedures, functions, synonyms, etc., and linked servers that point to other SQL Servers and MySQL servers.   I have some s...
API for GraphQL
Data Engineering
Data Pipeline
Lakehouse
  • nielsvdc's avatar
    nielsvdc
    7 months ago

    Hi amaaiia, you could think about the following.

     

    1. Consider migrating your db_info database to a Warehouse instead of a Fabric SQL Database. Warehouses also support stored procedures and temporary tables.
    2. For the SQL Server data that you now extract with linked servers, consider using mirroring the data to Fabric.
    3. For the MySQL server data you could also consider using open mirroring. But if that's too complecated you could also consider using pipelines or this notebook fabric-toolbox/samples/open-mirroring/mysql Mirroring/mysqlmirroring.ipynb at main · microsoft/fabric-toolbox

    Unfortunately we cannot yet create shortcuts in Warehouses (Vote for the idea), so you have to maybe have to use pipelines to get all the data together into the same Warehouse.

    Considerations 2-3 also work when you still choose to use Fabric SQL Database

     

    Hope it helps figuring this one out.

nielsvdc's avatar
nielsvdc
Super User
7 months ago

Hi amaaiia, you could think about the following.

 

  1. Consider migrating your db_info database to a Warehouse instead of a Fabric SQL Database. Warehouses also support stored procedures and temporary tables.
  2. For the SQL Server data that you now extract with linked servers, consider using mirroring the data to Fabric.
  3. For the MySQL server data you could also consider using open mirroring. But if that's too complecated you could also consider using pipelines or this notebook fabric-toolbox/samples/open-mirroring/mysql Mirroring/mysqlmirroring.ipynb at main · microsoft/fabric-toolbox

Unfortunately we cannot yet create shortcuts in Warehouses (Vote for the idea), so you have to maybe have to use pipelines to get all the data together into the same Warehouse.

Considerations 2-3 also work when you still choose to use Fabric SQL Database

 

Hope it helps figuring this one out.

  • v-dineshya's avatar
    v-dineshya
    Community Support
    7 months ago

    Hi amaaiia ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Hi nielsvdc , Thank you for your prompt response.

     

    Hi amaaiia , could you please try the proposed solution shared by  nielsvdc   ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

     

    Regards,

    Dinesh