Comparing data betn hetrogenous DBMS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Comparing data betn hetrogenous DBMS

I have a db on MYSQL and another on MSSQL.Each of these db have 1 table which holds 40000 approx records.I need to compare few coloumns of both tables.I cant go for a third party tool as my company is not ready to invest on this.Further I hav tested a few db comparison tool but unfortunately they cant be automated.
One way can be making a script which will connect to both the DBMS,get the result set and compare it.But dont know how to accompolish this.and automate by scheduler of windows or job.
If any one have ever solved this kind problem,pls suggest
You can use OLE DB or ODBC for MySQL, then add MySQL as linked server, and then comare tables with a simple script, such as:<br />select * from mysql_srv..t inner join t on… and so on <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />WBR, Vlad A. Scherbinin
I priviously tried a lot with creating link server and work accordingly;but unfortunately not successful
Specifically what errors are you getting?
]]>