Options
External objects
Boka
Posts: 32 Silver 3
in SQL Compare
SQL Compare ignore database scoped credentials. So you wont be able to create external data source from generated script.
Is that by design or something that you will change in the future?
Is that by design or something that you will change in the future?
Tagged:
Best Answer
-
Options
DanC
Posts: 591 Gold 4
Hi @Boka
I would advise posting the idea on the UserVoice forum here: https://redgate.uservoice.com/forums/141379-sql-compare
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers
Unfortunately, SQL Server does not allow access to the credentials, so it wouldn't be possible for SQL Compare to deploy database scoped credentials.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
It's clear that password is not accessible. Maybe just to prepare create statement with data available from sys.database_scoped_credentials without secret but with warning/comment?