mmexchange
asked on
Select table data from a different SQL instance?
I have a production SQL instance "Host1\SQL1" and a testing SQL instance "Host1\SQL2". I've trying to copy data from the Production SQL instance to the testing SQL instance, like this:
(but it isn't working) What as I missing?
(running SQL from "Host1\SQL2")
UPDATE PageTemplates
SET TemplateText =
(SELECT PT1.TemplateText
FROM [Host1\SQL1].MyDB.PageTemp lates AS PT1
WHERE (PT1.TemplateID = 1))
WHERE (TemplateID = 1)
(but it isn't working) What as I missing?
(running SQL from "Host1\SQL2")
UPDATE PageTemplates
SET TemplateText =
(SELECT PT1.TemplateText
FROM [Host1\SQL1].MyDB.PageTemp
WHERE (PT1.TemplateID = 1))
WHERE (TemplateID = 1)
why not use the impirt export tool within the server studio if its a direct copy from one to another
import*
ASKER
Just need a single row...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.