Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
pallavi_r
Super User
Super User

Migrate data from Sybase to MS Fabric

Dear All,

 

What is the ideal way to migrate data from Sybase to MS Fabric?

What are the different options and approaches? 

 

 

* Please refrain from giving responses from chatgpt, copilot. 🙂

Thanks,

Pallavi

2 ACCEPTED SOLUTIONS
v-pagayam-msft
Community Support
Community Support

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-database 

 

 vpagayammsft_0-1752045293233.png

 

If 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-overview 

 

Please 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-activity 

Please 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-dat...

Hope this helps.
Thank you.

Regards,
Pallavi.

 

View solution in original post

pallavi_r
Super User
Super User

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.

https://learn.microsoft.com/en-us/sql/ssma/sybase/migrating-sybase-ase-databases-to-sql-server-azure...

Step 2 - Then migrate from Azure SQL DB to MS Fabric using copy job, mirroring, multiple options are there

https://support.fabric.microsoft.com/en-ca/blog/sql-to-microsoft-fabric-migration-beginner-friendly-...

 

Please share if you have any different suggestion to this.

 

Thanks,

Pallavi

View solution in original post

4 REPLIES 4
pallavi_r
Super User
Super User

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.

https://learn.microsoft.com/en-us/sql/ssma/sybase/migrating-sybase-ase-databases-to-sql-server-azure...

Step 2 - Then migrate from Azure SQL DB to MS Fabric using copy job, mirroring, multiple options are there

https://support.fabric.microsoft.com/en-ca/blog/sql-to-microsoft-fabric-migration-beginner-friendly-...

 

Please share if you have any different suggestion to this.

 

Thanks,

Pallavi

v-pagayam-msft
Community Support
Community Support

Hi @pallavi_r ,
I hope the suggested solution worked for you. If you found any workaround,please share it the community and accept your answer as solution.It will be helpful for others who are facing similar issue.If it is not resolved, please feel free to reach out!
Thank you.

Hi @v-pagayam-msft ,

Thanks for your quick reply. The solution provided is for data connection and extraction. Would be great if you can share some insight on end to end migration methodology.

Thanks,

Pallavi

v-pagayam-msft
Community Support
Community Support

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-database 

 

 vpagayammsft_0-1752045293233.png

 

If 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-overview 

 

Please 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-activity 

Please 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-dat...

Hope this helps.
Thank you.

Regards,
Pallavi.

 

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.