What are the challenges you face when working across database platforms? Take the survey
Options

Comparing over the internet

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 25, 2005 10:13AM in SQL Compare Previous Versions
Hi Erik,

After having a look at SQl Compare, it doesn't seem to accept a port
number in the database connection dropdown. What you can do to get it
working is to go into your SQL Client Connection Manager on your computer
and create an alias to the server using TCP/IP, then connect to the distant
end server using the alias.

Please let me know if you need any more information.

Regards,

Brian Donahue
Red Gate Technical Support


"Erik" <x@x.nl> wrote in message news:kBmWvHG$DHA.700@server53...
> I am trying to compare my development database with my customer's
production
> database over the internet. The customer has a firewall, and has mapped
port
> 1433 internally to port 3391 externally.
>
> When I try to compare (local) with 123.123.123.123:3391 it does not work.
> How do I compare over the internet using a non-standard port?
>
> Thanks,
>
> Erik
>
>

Comments

  • Options
    The server box in SQL Compare will also allow you to manually type an address in SQL connection string format, which is:

    <PROTO>:<ADDRESS>,<PORT>

    For example:

    TCP:127.0.0.1,3391
This discussion has been closed.