I have been successfully connecting to Dynamics 365 Dataverse data using SQL Management Studio as well as ADO.NET connectors in SSIS.
I would LOVE it if i could setup a linked server here.. has anybody done this yet or do they know how too?
I would also LOVE if we can setup replication to a local SQL Server now instead of using Kingswaysoft packages for this. Is this possible yet?
Hi,
No you cannot setup a linked server - TDS just gives you read only access to one database.
Replication is possible using azure data factory - the other possible ways are mentioned here :
nishantrana.me/.../
PS
Great link Prateek! Hey, I'm not familiar with a vendor mentioned in that blog post: Skyvia. Do you have any experience with them?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
MVP-Daniyal Khaleel 67
Tom_Gioielli 24 Super User 2025 Season 2
mk1329 16