LutzM (1/28/2015)
Did you try use OPENQUERY to force the ORDER BY being performed at the MySQL side before transferring the data?What happens if you run that query directly at the MySQL Server? Does it perform acceptable?
Wow, OPENQUERY works great !
That gets my data to MSSQL. Can I use it to get data from MSSQL, and INSERT back to MySQL ?
I want to select data from my MSSQL table, and insert it into MySQL. But if OPENQUERY runs directly on the MySQL server, it won't have access to the MSSQL data ??
What I am doing is finding ID records in MSSQL, that are not in MySQL, and inserting them back to MySQL to keep the 2 servers in sync.
I had it working before with:
INSERT INTO MSQL_LINKED_SERVER...WP_USERS
SELECT FLD1, FLD2, FLD3
FROM MSSQL_TABLE
But now get the memory error also