on 2022 Aug 27 9:25 AM
I am trying to compare and update, insert, or delete to a remote MSSQL database. Connected MSSQL database to SQL Anywhere with remote server, and added a proxy table. Successfully inserted data from local table to remote proxy table with following query:
INSERT INTO Test (ID,Name) SELECT SOURCE.accno, SOURCE.particulars FROM "DBA"."acc_ledgers" SOURCE WITH WHERE NOT EXISTS ( SELECT * FROM Test TARGET WHERE TARGET.ID = SOURCE.accno ); COMMIT
I tried the same with update but it's showing error as :
Updated operation attempted on non-updatable remote query
My update query is:
UPDATE Test SET A.Name = B.particulars FROM Test as A,"DBA"."acc_ledgers" as B WHERE A.ID = B.accno
how to achieve this?. I am trying this for a long time, but didn't get any solution. Please help.. Thank you.
This is a task best suited for MobiLink, not proxy tables. Please see the comments on your initial question for further help in using MobiLink.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm not sure how else I can help. The forum, or any community for that matter, is great for asking a specific question and getting an answer, but comments along the lines of "cannot get a clear picture" will typically get answered with links to the documentation, which is what I will do again.
I would again suggest reading the "MobiLink - Getting Started" documentation, in particular the section entitled "MobiLink Synchronization".
While we don't have a tutorial specific to using MS SQL Server, I do believe that following the "Tutorial: Introducing MobiLink" tutorial, which sets up synchronization between two SQL Anywhere database will also help give you a solid understanding of the technology.
I will again suggest that on the machine where you have SQL Anywhere installed, you follow the "Tutorial: Introducing MobiLink" tutorial to setup synchronization between two SQL Anywhere databases. If you run into trouble during the tutorial, ask a specific question about the specific problem you are having in the tutorial, and it will almost certainly be answered.
Reg
User | Count |
---|---|
75 | |
9 | |
9 | |
8 | |
8 | |
7 | |
7 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.