Import RDD / Encrypted SQL connections
0 vote
My group recently moved from a locally hosted database to a cloud one. Previously, I had successfully connected in the office and via VPN on my Mac to the local DB.
When I went to import the RDD file after the migration to cloud, I saw that RDD wasn't enabled for Mac.
Is this due to not handling encrypted SQL connections? Am now no longer able to connect via Mac.
regards
Kim
All Comments (6)
Correct, currently the SQL data provider being used in the Mac version does not support encrypted SQL connections.
For example, connecting to Azure SQL will not work.
Stéfane Lavergne
It's a limitation that we have to live with unfortunately.
David Hervieux
Why do we have to live with this limitation? What prevents supporting it? It makes the Mac product unusable in a world where so much data is migrating to cloud. This forces me to remove the Mac product and run the Win version under mono/terminal. That's an ugly prospect.
Unfortunately it's just not implemented by Xamarin on Mac. We will add the support for that as soon as they have it implemented.
David Hervieux
The other solution is to use RDMS instead of a direct SQL Server connection.
David Hervieux
Thank you. Found out the infrastructure team just bought RDMS, so will try that once it's rolled out.