Compare table in production database and development database 1

[borisbe]

I'm using Crystal 9 and connecting to mysql.

We have a production database and a development database. Is there a way in crystal to compare the tables to make sure there are the same fields in a production database table and a development database table? Example:

Production table "class" fields:

term
subject
section

Development table "class" fields:

term
subject

I would want the report to show that the field "section" is not in Development table "class".

Help is very appreciated.

 

[lbass]

Are they both accessing the same server with the same driver, i.e., are both available in the table list?

-LB

 

[borisbe]

They are from different servers. I just found out for right now the user just wants to see if tables are missing in development that are not in production. I was able to complete queries in navicat and download the table names from both databases and do this comparison in Crystal.

Thanks LB for the quick reply. I think for right now, I'll wait to see if the user really does want the field comparison.