Click here to Skip to main content
14,326,421 members
Rate this:
Please Sign up or sign in to vote.
I am getting value from this server
select *from OPENROWSET('SQLNCLI',
'server=abc.xxx.x.xx;Uid=xyz;Pwd=#####;
database=[db];
Persist Security Info=False',
'select * from AlahlidbN.dbo.mstudent') as GetContractFromERP
where GetContractFromERP.IsSent=0 


Now i want to transfer records to Mysql stored procedure through linked server in MSSQL server
I am using like this.

What I have tried:

select *from OPENROWSET('SQLNCLI',
'server=abc.xxx.x.xx;Uid=xyz;Pwd=#####;
database=[db];
Persist Security Info=False',
'select * from AlahlidbN.dbo.mstudent') as GetContractFromERP
where GetContractFromERP.IsSent=0 

Exec  ('call mobileapp.sp_GetStudentContractFromERP('''''+GetContractFromERP.stdID+''',"GetContractFromERP.type","GetContractFromERP.text","GetContractFromERP.Msg","GetContractFromERP.show","GetContractFromERP.StdOne")') 
at LINKED 
Posted
Updated 5-Oct-19 3:49am
Comments
Gerry Schmitz 5-Oct-19 9:45am
   
Seems like a separate program that talked to both databases at the same time would be the more logical approach.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Seems like a separate program that talked to both databases at the same time would be the more logical approach.

Or again, stick the updates in a table, "import" that table, then process it on the receiving server.

You're dealing with 2 different platforms; don't bind them tightly.
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100