query: from mssql to myssql

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » query: from mssql to myssql

query: from mssql to myssql

Rate Topic

Display Mode

Topic Options

Author

Message

koen_huys

Posted Thursday, February 21, 2013 12:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:36 AM
Points: 8, Visits: 68

Like I posted before, I get the following error: Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "mysql" reported an error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 1

I can however access the database through openquery, but I need at this moment a query to transfer data from one database (mssql) to mysql

I have a table in mssql: appel with 5 coloms, col 1 till 5
I have a table in mysql: beer with 4 coloms, cal1 till 4

the first colom of table appel and beer have the same article
what i want is when an article in table appel = article table beer then he should copy the value in col 5 of table appel to the cal4 of table beer

hopefully somebody can help me

Post #1422418

« Prev Topic | Next Topic »

Permissions