Mirroring a SQl DB in Fabric/One Lake?

[newtonian1991]

Hello, 

We have recently begun using Fabric and my boss wants me to completely mirror a SQL databses from one of our vendors on Fabric/Onlake. This is due to the org moving in a different direction and will be cancelling the vendors contract and thus will eventually be cut off form that DB. He wants to ensure we having a working copy that we can utilise for creating silver and gold layers for reporting. 

From my understanding onelake isnt the best solution for this as there is no easy way to mirror and incrementally update the DB in fabric.

Is this correct? Any feedback or advice would be greatly appreciated. 

SQL DB:

Number of tables: 1256

Size: 20gb

[newtonian1991]

Thanks for your reply.

1) it is Microsoft SQL Server 2019

2)Yes it will eventualy be deleted/access removed. I guess mirroring isnt the correct term, perhaps cloning?

Kind Regards, 

Gregory

[NandanHegde · Accepted solution]

So basically you want to create a 1 time replica of the On Prem SQL server database in Fabric? and then move your downstreams to that new fabric object and eventually get rid of the on prem database?

If yes, then assuming the On Prem database was used just for Analytical and reporting purposes and not transactional purposes, then you can create a fabric warehouse and then create data pipelines to copy and load data from on prem into fabric warehouse to do a sync up of the data.

Note : fabric warehouse doesnt support all SQL key words supported by SQL server as of today.

In case if you want a lift and shift approach, then would suggest move the SQL server to Fabric SQL database

[v-menakakota]

Hi  @newtonian1991 ,
Thanks for reaching out to the Microsoft fabric community forum.

I would also take a moment to thank @NandanHegde   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Best Regards, 
Menaka.
Community Support Team

[v-menakakota]

Hi  @newtonian1991 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you. 

[v-menakakota]

Hi @newtonian1991 ,

Can you please confirm whether you have resolved the issue.

Thank you

[NandanHegde]

couple of queries :

1) It is which SQL database? SQL server (which version ) or Azure SQL database?

2) And would the SQL database be eventaully deleted ? If yes, then the mirroring cannot exist as the source is eventually deleted/dropped