How can we help you today? How can we help you today?

External objects

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?
Boka
0

Comments

3 comments

Sort by
  • DanC
    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.
    DanC
    0
  • Boka
    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?
    Boka
    0
  • DanC
    Hi @Boka

    I would advise posting the idea on the UserVoice forum here: https://redgate.uservoice.com/forums/141379-sql-compare
    DanC
    0

Add comment

Please sign in to leave a comment.