Can Linked Servers be used with Liquibase?

• Liquibase Secure (Pro)
• Liquibase Community (Open Source)

Conditions:

• Any version of Liquibase Secure (Pro) or Community
• Any version of SQL Server that has the ability to link servers

Question:

Can Liquibase deploy to databases linked to SQL Server or that are linked?

 

Answer:

Yes, linked servers in SQL Server can be accessed by Liquibase.

However, Liquibase doesn't allow multiple authenticated users, so it only passes credentials to the initial target database. You will need to ensure that the linked server is accessible to the target database that Liquibase connects to.

Related Article(s):

Create linked servers