Forum Discussion
Data replication in SQL server from fabric LH or WH using Polybase
HI Raavanan_7,
You can use fabric to get data from on premise SQL server through on-premises data gateway that hosted in the same network to access to the SQL server.
Getting On-Premises SQL Server Data to Microsoft F... - Microsoft Fabric Community
For polybase feature, I haven't found any documents mention it supported to work with fabric.Regards,
Xiaoxin Sheng
You could use pipelines to bring the data into Fabric One Lake and as you say it is going to be one-time, that would be the best solution until mirroring for on-premise SQL DB comes in.
But if you are moving from SQL Server, know that not all SQL features are supported in LH/WH SQL. For example, you cannot have MERGE statement nor Primary Key constraints.
In terms of Polybase, it would be very difficult to provide a solution unless we know the architecture used. But instead of Polybase, you can try using OLE DB connection (linked servers) which will allow you to do cross-querying between LH and SQL Server data.