RE: Link servers through proxy

changliw@xxxxxxxxxxxxxxxxxxxx (Charles Wang[MSFT]) wrote in
news:zmDIGfjsHHA.2528@xxxxxxxxxxxxxxxxxxxxxx:

Hi David,
I understand that you would like to fetch data from SQLREMOTE into
SQLTEST via your DEV computer since it can see both SQLREMOTE and
SQLTEST. You would like to know how to do that.
If I have misunderstood, please let me know.


[...]

Also, if the business logic is complex, you may write a T-SQL
statement to transfer the data. First run sp_addlinkedserver and
sp_addlinkedsrvlogin to add SQLREMOTE and SQLTEST as linked servers in
your SQL Server on the DEV computer. After that, you can query the
remote tables on SQLREMOTE and SQLTEST from DEV like this:
INSERT INTO SQLTEST.testdb.dbo.tableA SELECT column1, column2, column3
FROM SQLREMOTE.testdb.dbo.tableA


This is the approach I want to take.

BUT, I don't have a SQL server on the DEV computer -- I'm just running
the SQL client tools on the DEV server.

Hope this helps. If you have any other questions or concerns, please
feel free to let me know.


Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================

I would like to know how to get the SQLTEST SQL server to see the
SQLREMOTE SQL server.

If you could help me with that, it would be great.

Thanks.

David Walker
.

Relevant Pages

  • RE: Link servers through proxy
    ... Management Studio to access several database on the SQLREMOTE server ... I had thought that there was a SQL Server on your DEV computer. ... accessible from SQLTest to SQLREMOTE or SQLREMOTE to SQLTest. ...
    (microsoft.public.sqlserver.connect)
  • RE: Link servers through proxy
    ... I understand that you would like to fetch data from SQLREMOTE into SQLTEST ... Server Enterprise Manager, expand your server and Data Transfermation ... add SQLREMOTE and SQLTEST as linked servers in your SQL Server on the DEV ...
    (microsoft.public.sqlserver.connect)
  • RE: Link servers through proxy
    ... Management Studio to access several database on the SQLREMOTE server ... I had thought that there was a SQL Server on your DEV computer. ... from SQLTest to SQLREMOTE or SQLREMOTE to SQLTest. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
Loading