-
-
Notifications
You must be signed in to change notification settings - Fork 187
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unable to sync Sql Server tables with an XML datatype column #910
Comments
Because the If you are not explicitly using XQuery in your |
I do need to support XML columns. I've been hunting for the code that makes the GetChanges stored procedure, I'm hoping I can change the query when XML columns are present. |
It looks like I can add support for non-comparable columns (xml, text, ntext and maybe more if needed). I've got the code written and it appears to work in very early testing. |
Pull request submitted. Be aware that I have only tested it on the databases that I care about so additional testing would be prudent. Also, I am not currently using change tracking so I couldn't test that chunk. If you have any questions, let me know. |
Pull request #941 submitted to replace previous pull requests |
Hi |
When trying to Sync a table with an XML column using the SQL server client, and exception is thrown:
An unhandled exception of type 'Dotmim.Sync.SyncException' occurred in System.Private.CoreLib.dll
The xml data type cannot be selected as DISTINCT because it is not comparable.
├─ [SqlInstance].[DatabaseName].[DefaultScope].[InternalProvisionAsync].Provision:TrackingTable, StoredProcedures, Triggers.Overwrite:False.:The xml data type cannot be selected as DISTINCT because it is not comparable.
├── [SqlInstance].[DatabaseName].[DefaultScope].[InternalCreateStoredProceduresAsync].Table:RenewalRequest.Overwrite:False.:The xml data type cannot be selected as DISTINCT because it is not comparable.
├─── [DefaultScope].[InternalCreateStoredProcedureAsync].Table:RenewalRequest.StoredProcedure:SelectChanges.:The xml data type cannot be selected as DISTINCT because it is not comparable.
└──── The xml data type cannot be selected as DISTINCT because it is not comparable.
I'll look into the source code tomorrow to see if I can find a fix. If so, I'll post back and send a PR
The text was updated successfully, but these errors were encountered: