Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Linked Server Query Expand / Collapse
Posted Tuesday, June 18, 2013 11:32 AM


Group: General Forum Members
Last Login: Monday, December 1, 2014 9:05 PM
Points: 184, Visits: 653
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.
Post #1464808
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse