{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 家丑人穷心不美 的问题《What is best tool to compare two different Databas》','https://www.manongdao.com/q-754571.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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 ?
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
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".
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
I Found DB SOLO 4.2. Software on site : http://www.dbsolo.com/help/compare.html
and i checked it . thanks your time