Mohammed- I guess you are referring to use SSMS

Mohammed- It's as simple as using a copy activity in Azure Data Factory, you need to use `Copy data using pipeline` in Microsoft Fabric.

After create Lake house, there is an option to get data and select new data pipeline.

After create Data warehouse, there is an option to get data and select new data pipeline.

Then, choose the data source you want as SQL server from databases and the configure.

For more information, refer to below links:

Load Sample data to Data Warehouse

Quickstart: Create your first pipeline to copy data

Demo on The Ultimate Data Warehouse experience in Microsoft Fabric

Hope this helps.