Comparing over the internet

Brian Donahue

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
>
>

Brian Donahue

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