Link servers through proxy

My main development computer, XP Pro, (call it DEV) has 2 Ethernet
adapters. Adapter A goes out to a router, and can see the world, and
can see a remote SQL server (SQLREMOTE) that I have access to.

I can use SQL 2000 Enterprise Manager, Query Analyzer, and SQL 2005
Management Studio to access several database on the SQLREMOTE server
(default instance) using TCP/IP and an alias that I have set up, with a
specific port number.

Adapter B on my DEV computer is cabled directly to my SQL test computer
(SQLTEST) which only has one network adapter. On my DEV computer, using
the same three tools, I can see the databases on the SQLTEST computer
just fine.

This has worked for years. The DEV computer runs ProxyPlus to give the
SQLTEST computer some access to the Internet... for Windows Update and
such.

After all that was set up and working fine, I recently got a VPN
connection to the same network that the SQLREMOTE server lives on.
(Actually there are three SQL servers on that remote system.) This
might be an irrelevant detail.

Now I would like to link the two SQL servers together. I need to
occasionally get data from SQLREMOTE into SQLTEST. Since my DEV
computer can see both, it seems like this is doable.

I have read BOL and searched Google and haven't figured out how to do
this yet.

Q1: Are "Linked Servers" replacing "Remote Servers"? Do I have to worry
about "Remote Servers" at all?

Q2: Do I need a "route" statement on SQLTEST so that it can at least
ping the remote IP address that the SQLREMOTE server lives on?

Q3: Knowing "where" things actually run is a little confusing. When I
have a query window open on SQLREMOTE, it seems as if I am "at" the
remote location: I can't do a Bulk Insert using local drive letters,
for example. This is never made quite clear in the documentation that I
have read.

(If I use the tool SQLDelta on my DEV computer, I can link to both
SQLTEST and SQLREMOTE and synchronize data or schemas. This apparently
makes two separate connections and acts as the middleman.)

Do I actually need for SQLTEST to link to (or "see") SQLREMOTE in order
to perform distributed queries that use data from both servers?

Thanks for any advice or pointers.

David Walker




.

Relevant Pages

  • 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)
  • 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: What is your database application development environment?
    ... development, then switch to the Test or QA database for optimization, ... both our Dev and QA processes used smaller databases. ... have DEV boxes or CPU cycles that closely resemble QA and production. ... each running SQL Server Developer. ...
    (borland.public.delphi.non-technical)
  • RE: Build Solution from network share in VS2005 wont work - please he
    ... So the problem seems due to the file share communication between your WIN ... 2003 server and WIN XP work station (dev box). ... Build Solution from network share in VS2005 won't work - please ...
    (microsoft.public.dotnet.framework.aspnet)