• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

redgate mysql compare how do I connect to two remotely hosted databases?

I have shared hosting apache php 4.4.8 mysql 4.1.22.

I want to compare the structure using redgate's mysql compare.  How do I connect to these dbs?  Is there a port I need to specify?  It is even possible?

Thanks, I don't know too much about apache.
0
jackjohnson44
Asked:
jackjohnson44
  • 3
1 Solution
 
tlovieCommented:
I think that redgate's tools are for MS SQL Server version.  I'm not aware of their tools working on MYSQL

you could use http://www.quest.com/toad-for-mysql/ I believe it has compare features
0
 
jackjohnson44Author Commented:
0
 
tlovieCommented:
The screenshot shows that you have to enter the login credentials for both databases.  In the example, you put in the server/port combination.  You'd have to probably configure MySql to use TCP sockets, rather than unix pipes.

http://www.red-gate.com/products/MySQL_Compare/index.htm?gclid=CJ-kgf-TiKQCFZpN5QoduVOTLA

other than that, red-gates tools are incredbibly easy to use!!
0
 
tlovieCommented:
Also note that Red-gate's mysql compare is for Mysql version 5.0 and greater.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now