Forum Discussion
Migrate data from Sybase to MS Fabric
- Anonymous1 year ago
Hi pallavi_r ,
Thank you for using Microsoft Fabric Community Forum!
There is a sybase connector in dataflow which you can use to get data from your database to Fabric.Refer the link:
https://learn.microsoft.com/en-us/power-query/connectors/sybase-databaseIf that does not match your requirement perfectly, Try using REST connector in Data pipleine to get data from your database into Fabric.
Source: https://learn.microsoft.com/en-us/fabric/data-factory/connector-rest-overviewPlease follow this document to know how to configure copy activity in fabric using REST:
https://learn.microsoft.com/en-us/fabric/data-factory/connector-rest-copy-activityPlease follow this document to know how to set up a connection to use REST connector in data pipeline:
https://learn.microsoft.com/en-us/fabric/data-factory/connector-rest#set-up-your-connection-in-a-data-pipeline
Hope this helps.
Thank you.
Regards,
Pallavi. - 1 year ago
Hi All,
Just taking this approach as per below references from Microsoft link.
Step 1 - Keep azure sql db as staging environment and use SSMA to do the schema and data migration.
Step 2 - Then migrate from Azure SQL DB to MS Fabric using copy job, mirroring, multiple options are there
Please share if you have any different suggestion to this.
Thanks,
Pallavi
Hi All,
Just taking this approach as per below references from Microsoft link.
Step 1 - Keep azure sql db as staging environment and use SSMA to do the schema and data migration.
Step 2 - Then migrate from Azure SQL DB to MS Fabric using copy job, mirroring, multiple options are there
Please share if you have any different suggestion to this.
Thanks,
Pallavi