I need to know the ports that compare and data compare use. I have a dev DB and a production DB and I have to request the ports to be opened up between the 2 servers so I can use these tools.
These programs simply use the SQL Server ports. By default 1433, unless you set the server up to use a custom one. I believe you'll also need 1434 for server discovery to work, but I don't think it's strictly necessary.
Thanks