Visual Studio Integration - Calls to Linked Servers
ScopeCreep247
Posts: 5 New member
My development team is using Redgates SQL Source Control tool with Visual Studio database projects. One enhancement that would be huge for my team is better handling of calls to external databases.
In visual studio, you can add database references to a database project in eliminate build errors from calls to SQL objects in another database. Visual Studio then allows you to use your database references by prefixing the "$" sign to the reference alias. This works great.
The problem is, when you push this to your repository, the $ notation is included instead of the name of the linked server. This causes execution errors when you end up with something that looks like this in your calling object
Example:
Select *
FROM $([My_Database_Reference]).[My_Schema_Name].[My_Object_Name]
Would it be possible for redgate to somehow remove the $ notation and replace it with the actual name of the external database?
In visual studio, you can add database references to a database project in eliminate build errors from calls to SQL objects in another database. Visual Studio then allows you to use your database references by prefixing the "$" sign to the reference alias. This works great.
The problem is, when you push this to your repository, the $ notation is included instead of the name of the linked server. This causes execution errors when you end up with something that looks like this in your calling object
Example:
Select *
FROM $([My_Database_Reference]).[My_Schema_Name].[My_Object_Name]
Would it be possible for redgate to somehow remove the $ notation and replace it with the actual name of the external database?
Tagged:
Answers