What are the challenges you face when working across database platforms? Take the survey

External objects

BokaBoka Posts: 32 Silver 3
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?

Best Answer


  • Options
    Hi @Boka

    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?

  • Options
    BokaBoka Posts: 32 Silver 3
    Hi @DanC
    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?
Sign In or Register to comment.