How can we help you today? How can we help you today?

Running Compare Across VPN

Hi,

in the current version of SQL Compare I can compare databases across a VPN. (after using the Client Network Utility in SQL Server to register an alias on the TCP/IP library).

This is a real selling point for us as we can connect across the VPN and synchronise with databases running remotely on client sites.

In the Sql Bundle 5 beta I cannot register the remote server.

Is this something that has just been missed or functionality that will no longer be available in the product ?

Gazza
Gazza
0

Comments

4 comments

  • Neil Davidson
    Gazza,

    This should still work in v 5. Can you let me know what error you're getting back?

    - Neil
    Neil Davidson
    0
  • Gazza
    Ok,

    I have a remote server registered (through the SQL Client Network utility).

    I have v4 and the beta of v5 on my machine.

    I'm using SQL Server 2k.

    In v4 when running either of the compare utilities the alias of this server appears in the drop down of registered servers.

    In v5 the server is NOT in the drop down.

    If I try and force the issue by typing in the server alias, then the application hangs when I try and select from the database combo.

    p.s. This is great functionality in v4 - a real selling point....

    Gazza
    Gazza
    0
  • Neil Davidson
    Gazza,

    How long does the application hang for? It should come back to life eventually. When it does, what error does it give?

    Also, can you connect by IP address?
    Neil Davidson
    0
  • Gazza
    Hi Neil,

    it's coming back now.

    I connected to the database using query analyzer (the first time I had done this since the install of v5), and I can now force Sql Data Compare to connect by typing in the alias of the server. So maybe some sort of registry thing ?

    The server does not appear in the drop down list of servers though (as it does in Query Analyzer). But I can work around this.

    cheers
    Gary
    Gazza
    0

Add comment

Please sign in to leave a comment.