SQL Server Mirroring 6 - Forced Service Role Switching in SQL 2019 Mirroring

How to force switch role in SQL 2019 database mirroring? how to remove or resume mirroring?

[@kghazi123]

Hello Mandar, My company requests to build a central data warehouse repository for mainly reporting purpose and can enable business users to geneare their own reports. Hpw can we as IT achive that? Await for your valuable input.

[@mrgogate]

Hi Khalid, best way is to pull the data incrementally in separate datawarehouse server - based on creation and updation date - and there after create data warehouse solution. If your source tables doesn't have creation or updation dates, you can try change data capture (CDC) to load data into datawarehouse environment. Please refer following following link for details. github.com/magogate/DataWarehouse_And_Reporting