Post reply

Getting result from different server and using it in another server

  • June 11, 2012 at 1:18 am

    #392476

    Hi,

    I have a tableA in server X. I need to query TableA to get couple of column data results and then use those results in a query used in Server y. It would be a no-brainer to use linked server. But both servers cannot be linked due to some restrictions. How can I do that?

  • June 11, 2012 at 1:33 am

    #1499184

    How up to date does the data in tableA need to be for querying?

    You could use something like SSIS to copy data from server1 to server2, replication is also an option especially if you need sort of real time data.

  • June 11, 2012 at 2:00 am

    #1499188

    Openrowset()

    http://msdn.microsoft.com/en-us/library/ms190312.aspx

    Or xp_cmdshell then bcp the table over to server x.

    Both commands need to be enabled though

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply