14,494 questions
Dotmim.Sync is compatible with sqlite-net-pcl now :)
See more here : https://github.com/Mimetis/Dotmim.Sync/discussions/517
How to sync SQLite Databae with SQL Database
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 90%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESI%3C/text%3E%3C/svg%3E)
Seth Isaacks
51
Reputation points
I have been researching this a long time and everything I have tried has resulted in a dead end.
I have an Xamarin Cross Platform App leveraging the sqlite-net-pcl.....as the tutorials tell you.
However, the app will have the option to connect to a server that has a sql database....and I need to sync the data back and forth.
Apparently the current tutorials for doing this with azure....do not work. I have spoken to some of the top Azure people and from my understanding Azure mobile apps is going through a rework.
So I tired Dotmim Sync....but sqlite-net-pcl is not compatible with Dotmim Sync
Any help with this would be much appreciated.
SQL Server Other
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 68%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sébastien Pertus 1 Reputation point Microsoft Employee2021-04-17T19:18:14.12+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 65%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
sojan.net 0 Reputation points2023-07-17T05:54:26.5666667+00:00 Hi Sébastien Pertus,
How are you? Hope you are well
Does Dotmim.Sync syncs with MAUI-Android, and MAUI-iOS ?
i tried syncing my local SQL Server with SQLite on Windows-MAUI. - it works
i tried syncing Azure SQL-Server with SQLite on Windows-MAUI. - it shows error , not sure what it is
i tried syncing Azure SQL-Server with SQLite on Android-MAUI. - It is connecting , but then it results into an error
My Code
SqlSyncProvider serverProvider = new SqlSyncProvider( @"Data Source=xxxxx.database.windows.net; Initial Catalog=CORETEST; Integrated Security=false; MultipleActiveResultSets=False; User ID=username;Password=xxxxxxxx"); SqliteSyncProvider clientProvider = new SqliteSyncProvider(appPath + @"//CORETEST.db"); var setup = new SyncSetup("PROJECT"); SyncAgent agent = new SyncAgent(clientProvider, serverProvider); var result = await agent.SynchronizeAsync(setup); ```
Sign in to comment -
-
Olaf Helper 47,436 Reputation points2023-07-17T06:15:58.8566667+00:00 Other good tool: https://github.com/ErikEJ/SqlCeToolbox