Forum Discussion
Solved
How to replace linked server calls in SQL server?
I have two SQL Server database instances - let's call them server A and B. Sadly, as the user traffic decreases, there is now no need for running two servers anymore. So I'm planning to merge databa...
intackchoi , use SSDT = SQL Server Database Tools, create a database project, import database design, replace all references to the linked server and deploy the changes to your SQL Server.
intackchoi , use SSDT = SQL Server Database Tools, create a database project, import database design, replace all references to the linked server and deploy the changes to your SQL Server.