I created Linked server in Sql server 2005 and tried Data Migration from MySql to MS Sql 2005 but some of the data got rejetced and i need to find out that which data got rejected?I was trying to use following query but looks like i am having correct syntex issue:

select * from OPENQUERY (MyLinkedServer, 'select * from CInfo where ID NOt IN (select ID from Cinfo)')A

ID is my PK column, i have both the table name is same both the DB - MySql and MS Sql.Only DB Name is different like - MySQLCInfoDB and in MS Sql - InfoSqlDB.