Is there any support for image, nText datatype

[arjunbharara]

.It is throwing me a exception which is ntext from provider SqlSyncProvider, Dotmim.Sync.SqlServer.SqlSyncProvider is not currently supported.'

[Mimetis]

As said, it's not supported.
My advice: Change ntext to varchar(max)

[Mimetis]

and change Image to varbinary(max)

[arjunbharara]

thank you for your reply .
i had one more question
By using SetCreateProceduresForAdditionalScopeDefault, you can prevent redundant stored procedures from being created, reducing the number of database objects and improving maintenance efficiency. When additional scopes for the same table do not require unique stored procedures (i.e., they share similar filtering or data requirements), you can reuse the existing procedures. This approach optimizes storage and minimizes the complexity of managing multiple scopes, especially when the same tables are involved in each scope.
can we do the same in Dtmim ?

[Mimetis]

No, each scope has its own set of stored procedures.

That being said, it something we can think about, but definitively not in my priority list :)

[arjunbharara]

What are the alternate if do not want to upgrade my database from using image and nText dataType. because migrating my database would cost me a lot work and data changes.

[Mimetis]

if you want to use DMS, as is, there is no option.
Otherwise you can look at this PR (#941), but it's quite old, and not up to date with the latest changes.
Honestly it's a lot of changes in DMS, and I decided to not incorporate it in the master branch.

You can take a look, but there is no guarantee.

[arjunbharara]

Beside Text ,nText and image data types is there any other data types which are not supported by the sqlSyncProvider?
Does it support xml datatype if no why (because i has not been deprecated by sql server ).
It will be great if you can update the documentation to the latest version.
thank you.