0

I have two database , First Db is Microsoft SqlServer (version 2008 R2) and second database is DB2

i need a tool for comparing schema and tables in both ot them ? is every body have idea or solution ?

Harry Sarshogh
  • 2,137
  • 3
  • 25
  • 48
  • i search at google and found a lot of tools which them designed for One type of DBMS – Harry Sarshogh May 20 '13 at 12:19
  • Consider asking at dba.stackechange.com – WarrenT May 20 '13 at 12:53
  • It does not meet criteria for this site. It is off topic, not a specific programming problem, and seeks opinion-based answers. See about [http://stackoverflow.com/about] above. It would be better placed on the sister site for database administrators [http://dba.stackexchange.com]. The down vote was not meant personally, but it was my hope that it might help attract moderator attention, so that they would move it for you. – WarrenT Oct 29 '13 at 17:32

3 Answers3

4

I think IBM Data Studio can do that. I don't know if it's the best tool, as you didn't say how you'd define "best".

mustaccio
  • 18,234
  • 16
  • 48
  • 57
3

I Found DB SOLO 4.2. Software on site : http://www.dbsolo.com/help/compare.html

and i checked it . thanks your time

Harry Sarshogh
  • 2,137
  • 3
  • 25
  • 48
  • at another post in stackoverflow by link saied other desctiption : http://stackoverflow.com/questions/225772/compare-two-mysql-databases – Harry Sarshogh May 20 '13 at 12:16
2

Try using the Toad or else you can also use SQL Developer. Although SQL Developer would be a better option as you can view your MySQL database objects in it and once the DB2 Catalogs entry has been made, you can view the database objects of DB2 as well through the same tool.

Hope that helps.

Regards, DB2 DBA

Aman Singh
  • 1,111
  • 3
  • 17
  • 31