Migration question with Slqlite and Sql Azure Database

[sisaacks]

I have a Xamarin Mobile Application that houses a local sqlite database
I am currently syncing to a Azure Sql Database for the backend
My question is about migrations, in the examples posted on here, it says to have two sql sync providers....one for the client and one for server.

However my sync I have a WebClientOrchestrator and a SqliteSyncProvider. Should I be using those for migration vs two SqlSyncProviders?

Also, when I add the property to my model on the client side, sqlite automatically generates the field under the hood. So do I still need to have a client provider for migration?

Also can I handle the server on the client side....I need the Azure Sql Server connection string. Being that the phone holds the sqlite db, i would not have access to the client database on the server. So I am not sure if the client should be handled on the client and the server should be handled in the web api? I am not even sure how you would set that up in the web api?

I put all the code on the client side but when I call
var serverProvider = new SqlSyncProvider(serverDbConnectionString);
I get the following error: System.PlatformNotSupportedException: Strings.PlatformNotSupported_DataSqlClient
at Microsoft.Data.SqlClient.SqlConnectionStringBuilder..ctor (System.String connectionString)

I am assuming I need to put the code in the web api, but I am not sure how to call from the client to the web api and tell it to migrate the data? Can someone explain what I need to do?

[sisaacks]

I followed the github esxample and updated the server for MIGRAtION. However now when I try to sync from the client mobile device I am getting the following error below. Can anybody help me with what is going on here? I am obviously doing something wrong.

Here is my code on the web api....I checked and the stored procs are updated correctly so I am unclear as to why I am getting this error

`try
{
// START MIGRATION ON SERVER
var serverProvider = new SqlSyncProvider(connectionString);

var migrationSyncOptions = new SyncOptions();

// Creating a setup regarding only the table Address
var setupAddress = new SyncSetup(new string[] { "Vehicle" });

// Create a server orchestrator used to Deprovision and Provision only table Address
var remoteOrchestrator = new RemoteOrchestrator(serverProvider, migrationSyncOptions, setupAddress);

// Unprovision the old Address triggers / stored proc.
// We can conserve the Address tracking table, since we just add a column, 
// that is not a primary key used in the tracking table
// That way, we are preserving historical data
await remoteOrchestrator.DeprovisionAsync(SyncProvision.StoredProcedures | SyncProvision.Triggers);

// Provision the new Address triggers / stored proc again, 
// This provision method will fetch the address schema from the database, 
// so it will contains all the columns, including the new Address column added
await remoteOrchestrator.ProvisionAsync(SyncProvision.StoredProcedures | SyncProvision.Triggers);

}
catch (Exception ex)
{
var ruhRohShaggy = ex.ToString();
}`

{Dotmim.Sync.Web.Client.HttpSyncWebException: Invalid object name 'Vehicle_tracking'.

at Dotmim.Sync.RemoteOrchestrator.ApplyThenGetChangesAsync(ScopeInfo clientScope, BatchInfo clientBatchInfo, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress) at Dotmim.Sync.Web.Server.WebServerOrchestrator.ApplyThenGetChangesAsync2(HttpContext httpContext, HttpMessageSendChangesRequest httpMessage, SessionCache sessionCache, Int32 clientBatchSize, CancellationToken cancellationToken, IProgress1 progress)
at Dotmim.Sync.Web.Server.WebServerOrchestrator.HandleRequestAsync(HttpContext httpContext, Action1 action, CancellationToken cancellationToken, IProgress1 progress)

---

INNER EXCEPTION

Invalid object name 'Vehicle_tracking'.

at Microsoft.Data.SqlClient.SqlCommand.<>c.b__203_0(Task1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke()
at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
at Dotmim.Sync.BaseOrchestrator.ReadSyncTableChangesAsync(SyncContext context, SyncTable syncTable, BatchInfo batchInfo, MessageGetChangesBatch message, DatabaseChangesSelected changesSelected, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress) at Dotmim.Sync.BaseOrchestrator.InternalGetChangesAsync(SyncContext context, MessageGetChangesBatch message, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)
at Dotmim.Sync.RemoteOrchestrator.ApplyThenGetChangesAsync(ScopeInfo clientScope, BatchInfo clientBatchInfo, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress) at Dotmim.Sync.RemoteOrchestrator.ApplyThenGetChangesAsync(ScopeInfo clientScope, BatchInfo clientBatchInfo, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)

at Dotmim.Sync.Web.Client.HttpRequestHandler.HandleSyncError (System.Net.Http.HttpResponseMessage response) [0x002b2] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
at Dotmim.Sync.Web.Client.HttpRequestHandler.SendAsync (System.Net.Http.HttpClient client, System.String requestUri, System.String sessionId, System.String scopeName, Dotmim.Sync.Web.Client.HttpStep step, System.Byte[] data, System.String ser, Dotmim.Sync.Serialization.IConverter converter, System.String hashString, System.String contentType, System.Threading.CancellationToken cancellationToken) [0x0036c] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
at Dotmim.Sync.SyncPolicy.InternalExecuteAsync[TResult] (System.Func1[TResult] operation, System.Threading.CancellationToken cancellationToken, System.Object arg) [0x00103] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.Web.Client.HttpRequestHandler.ProcessRequestAsync (System.Net.Http.HttpClient client, System.String baseUri, System.Byte[] data, Dotmim.Sync.Web.Client.HttpStep step, System.Guid sessionId, System.String scopeName, Dotmim.Sync.Serialization.ISerializerFactory serializerFactory, Dotmim.Sync.Serialization.IConverter converter, System.Int32 batchSize, Dotmim.Sync.SyncPolicy policy, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x0037f] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
at Dotmim.Sync.Web.Client.WebClientOrchestrator.ApplyThenGetChangesAsync (Dotmim.Sync.ScopeInfo scope, Dotmim.Sync.Batch.BatchInfo clientBatchInfo, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00447] in <4080d9514c944cf4b3ae889fb07b8e3b>:0 at Dotmim.Sync.SyncAgent+<>c__DisplayClass53_0.<SynchronizeAsync>b__0 () [0x00e09] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.SyncAgent.SynchronizeAsync (Dotmim.Sync.Enumerations.SyncType syncType, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00185] in <4c312695a8674d6890ba8c3e768d18bc>:0
at AutomobileApp.Services.NFODataService.SyncData () [0x00137] in C:\SandBox\AutomobileApp\AutomobileApp\AutomobileApp\Services\NFODataService.cs:195 }

[Mimetis]

Seems you have deleted the tracking table on your server
Try to provision again with tracking table.
By the way if you have dropped the tracking table, you have lost all the tracking info for each row of your table

[sisaacks]

Hmmm all i did was an EF migration, not sure how that would have been deleted? So its a server issue not the local sqlite database? For the EF migration, I used visual studio package manager console Then I ran the code for the server in the web api, everything seemed to update correctly. I didnt see a tracking table before or after on the server. Where would the tracking table be? I spoke to my boss, he said if you have the time to help with this, we will pay. Seth

…

On Thu, May 12, 2022 at 2:21 PM Sébastien Pertus ***@***.***> wrote: Seems you have deleted the tracking table on your server — Reply to this email directly, view it on GitHub <#734 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOZ5VYFUUMIKXTXAGTJOEQDVJVY6VANCNFSM5VWHRNCA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[sisaacks]

Here are my tables before the migration...essentially the very first sync [image: image.png] On Thu, May 12, 2022 at 2:32 PM Seth Isaacks ***@***.***> wrote:

…

Hmmm all i did was an EF migration, not sure how that would have been deleted? So its a server issue not the local sqlite database? For the EF migration, I used visual studio package manager console Then I ran the code for the server in the web api, everything seemed to update correctly. I didnt see a tracking table before or after on the server. Where would the tracking table be? I spoke to my boss, he said if you have the time to help with this, we will pay. Seth On Thu, May 12, 2022 at 2:21 PM Sébastien Pertus ***@***.***> wrote: > Seems you have deleted the tracking table on your server > > — > Reply to this email directly, view it on GitHub > <#734 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AOZ5VYFUUMIKXTXAGTJOEQDVJVY6VANCNFSM5VWHRNCA> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >

[sisaacks]

I am not sure what else to do, I have done everything your directions say to do but it will not work. Instead of doing the migration, I added the new column as per your example. I then ran just the web api...by pressing PLAY on the project. Then I checked the azure database to make sure it updated which it did. Then I went back to my mobile app and ran the app and updated the Sqlite Database per your instructions. Then I tried to sync the data and I get the same error again. Without someone help that is more knowledgeable, it does not appear it will work with Xamarin and Sqlite Regards Seth Isaacks On Thu, May 12, 2022 at 3:29 PM Seth Isaacks ***@***.***> wrote:

…

Tables after migration [image: image.png] On Thu, May 12, 2022 at 2:36 PM Seth Isaacks < ***@***.***> wrote: > Here are my tables before the migration...essentially the very first sync > > [image: image.png] > > On Thu, May 12, 2022 at 2:32 PM Seth Isaacks < > ***@***.***> wrote: > >> Hmmm all i did was an EF migration, not sure how that would have been >> deleted? >> So its a server issue not the local sqlite database? >> For the EF migration, I used visual studio package manager console >> Then I ran the code for the server in the web api, everything seemed to >> update correctly. >> I didnt see a tracking table before or after on the server. Where would >> the tracking table be? >> I spoke to my boss, he said if you have the time to help with this, we >> will pay. >> >> Seth >> >> On Thu, May 12, 2022 at 2:21 PM Sébastien Pertus < >> ***@***.***> wrote: >> >>> Seems you have deleted the tracking table on your server >>> >>> — >>> Reply to this email directly, view it on GitHub >>> <#734 (reply in thread)>, >>> or unsubscribe >>> <https://github.com/notifications/unsubscribe-auth/AOZ5VYFUUMIKXTXAGTJOEQDVJVY6VANCNFSM5VWHRNCA> >>> . >>> You are receiving this because you authored the thread.Message ID: >>> ***@***.***> >>> >>

[sisaacks]

Something just occurred to me, I have been turning change tracking on for the entire server database...should I only be doing that per table? Just trying to figure out why I am getting the errors I am getting. On Thu, May 12, 2022 at 5:39 PM Seth Isaacks ***@***.***> wrote:

…

IN the migration sample you have, if I run your example on the mobile side I get an exception stating: {System.PlatformNotSupportedException: Strings.PlatformNotSupported_DataSqlClient at Microsoft.Data.SqlClient.SqlConnectionStringBuilder..ctor (System.String connectionString) [0x00006] in /_/artifacts/Project/obj/Release.AnyCPU/Microsoft.Data.SqlClient/netcore/Microsoft.Data.SqlClient.notsupported.cs:504 at Dotmim.Sync.SqlServer.SqlSyncProvider..ctor (System.String connectionString) [0x00021] in <aa4426aee7564ab09ad93bdbfadb609f>:0 at AutomobileApp.Services.NFODataService.Test () [0x0008e] in C:\SandBox\AutomobileApp\AutomobileApp\AutomobileApp\Services\NFODataService.cs:191 } On Thu, May 12, 2022 at 4:43 PM Seth Isaacks < ***@***.***> wrote: > I am not sure what else to do, I have done everything your directions say > to do but it will not work. > Instead of doing the migration, I added the new column as per your > example. > I then ran just the web api...by pressing PLAY on the project. > Then I checked the azure database to make sure it updated which it did. > Then I went back to my mobile app and ran the app and updated the Sqlite > Database per your instructions. > Then I tried to sync the data and I get the same error again. > Without someone help that is more knowledgeable, it does not appear it > will work with Xamarin and Sqlite > > Regards > Seth Isaacks > > On Thu, May 12, 2022 at 3:29 PM Seth Isaacks < > ***@***.***> wrote: > >> Tables after migration >> >> [image: image.png] >> >> On Thu, May 12, 2022 at 2:36 PM Seth Isaacks < >> ***@***.***> wrote: >> >>> Here are my tables before the migration...essentially the very first >>> sync >>> >>> [image: image.png] >>> >>> On Thu, May 12, 2022 at 2:32 PM Seth Isaacks < >>> ***@***.***> wrote: >>> >>>> Hmmm all i did was an EF migration, not sure how that would have been >>>> deleted? >>>> So its a server issue not the local sqlite database? >>>> For the EF migration, I used visual studio package manager console >>>> Then I ran the code for the server in the web api, everything seemed >>>> to update correctly. >>>> I didnt see a tracking table before or after on the server. Where >>>> would the tracking table be? >>>> I spoke to my boss, he said if you have the time to help with this, we >>>> will pay. >>>> >>>> Seth >>>> >>>> On Thu, May 12, 2022 at 2:21 PM Sébastien Pertus < >>>> ***@***.***> wrote: >>>> >>>>> Seems you have deleted the tracking table on your server >>>>> >>>>> — >>>>> Reply to this email directly, view it on GitHub >>>>> <#734 (reply in thread)>, >>>>> or unsubscribe >>>>> <https://github.com/notifications/unsubscribe-auth/AOZ5VYFUUMIKXTXAGTJOEQDVJVY6VANCNFSM5VWHRNCA> >>>>> . >>>>> You are receiving this because you authored the thread.Message ID: >>>>> ***@***.*** >>>>> com> >>>>> >>>>

[sisaacks]

Has anyone successfully done sqlite to sql in an xamarin project? I cannot get this to work. Please help

[matevzcesar]

I work on a project using sqllite clientside with xamarin and sql server server side. If i understand correctly, you are having issues with changing your setup?
What we do for updates is, when we are doing major changes on the database that also affect the setup configuration, we define a new scope setup and run in it parallel with the old setup, so that all clients remain compatible. Once the client gets an update, we first sync to the old scope, to make sure all the changes are uploaded, deprovision the old scope and then sync to the new scope. Once all clients have migrated you can deprovision old scopes on the server.

[sisaacks]

@matevzcesar -- What I am referring to is when you have to change the schema of the synced databases...for example I need to add a column to an already existing table. When I try to sync after doing that, following the migration process in the documentation, I get an error stating that the tracking table cannot be found.

1. When you say define a "new scope" do you mean defining like this?
   var setup = new SyncSetup(new string[] { "Address", "Customer", "CustomerAddress" });

2. What do you mean by running parallel? Can you explain how that works? Do you have an example?

3. "Once the client gets an update, we first sync to the old scope, to make sure the changes are uploaded" Are you saying and update from the server? How do you deprovision the old scope on the client?

4. "Once all the clients have migrated you can deprovision the scopes on the server" By clients to you mean all the mobile devices running the app? How do you know when all clients have been updated? It seems like that would be hard to tell?

If you have any examples that would be great. I have been spinning my wheels on this for a couple weeks.

In my Xamarin app, I am using Sqlite and tables are automatically created and updated for me based on how I initialize. For example: connection.CreateTable(). Where "MyTable" is just a class. So if I add another property to the class, Sqlite will automatically update the table. Maybe this is where the issue is? Its just frustrating I followed the documentation but it fails every time I add a column to a table.

Any help would be much appreciated

[matevzcesar]

So first off, if you're only adding a column to your setup, the migration process is handled automatically by the library. There is no migration process other than calling SynchronizeAsync(), which is pretty neat. This is mentioned in the documentation.

Second, I don't quite understand why you're adding a table on the client side manually? I was under the impression your origin for the tables was an sql server?

And to explain our use-case using multiple scopes. Let's say you have been using a scope setup named "Scope1" and you want a major app update, where you don't want to sync some tables anymore and you also want to add new ones. Since you can not control when your clients (mobile devices) are going to install an update, you can just create a completely new scope containing all the tables you want to use in the new version of your application. So in addition to your "Scope1" provider, you add another provider for "Scope2" services.AddSyncServer< SqlSyncChangeTrackingProvider >(scope1); services.AddSyncServer< SqlSyncChangeTrackingProvider >(scope2);, if you're using http mode that is (be advised this is pseudocode, please lookup AddSyncServer definition). And in the new version of your app, you sync to "Scope2". This way, you retain compatibility to clients using both versions of the application.

You were also asking how to deprovision the old scope from the client. LocalOrchestrator has the method needed for this DeprovisionAsync.

[sisaacks]

@matevzcesar

1. In regards to your first comment that is if your ONLY changing TABLES...meaning adding/removing a TABLE. If you scroll farther down you will see the following: "During any dev cycle, you will probably have to make some evolutions on your server database.
   Adding or deleting columns will break the sync process. If you are removing or adding a column from a table on your server: You can’t use this technic to migrate your clients database. DMS won’t be able to make an Alter table to add / remove columns. Too complicated to handle, too much possibilities and scenario." It describes how you must migrate the data on the server and the client.
   The migration example be found here: Migration Sample

2. In regards to your second comment, No the client has to be the primary database. Our app will primarily be used offline, so it does not make a lot of sense for the sever to be our primary. I followed the Xamarin Tutorial about how to add sqlite-net-pcl to the project. Maybe your suggesting that is what is wrong? I am not sure how I would go about it any other way? Essentially the sever is backup for us....when the app starts, if online...we always want to pull and push.

So essentially when I follow the migration process......the second sync I do, I get an error stating that the Tracking Table is missing. But I took a snapshot of the sql azure database before and after and neither time did it have a table with that name. I have spent WEEKS trying to get this to work but ultimately fails every time.

So on the client when I create my sqlite database it looks like the syntax below. So if I was to add an additional property to the MyTable class, sqlite will update the table on app start:

connection = SQLite.GetConnection(DatabaseName);
CreateTable<MyTable>();
 private void CreateTable<T>()
        {
            lock (locker)
            {
                connection.CreateTable<T>();
            }
        }

public Class MyTable
{
    // class properties 
}

[sisaacks]

Sebastian I do not believe DotmimSync will work with Xamarin and Sqlite. Your software is expecting a Vehicle_Tracking table that simply does not exist in the database. I have a table called [dbo].[MSchange_tracking_history] but there is not a Vehicle_Tracking. I have followed your online examples on github for migration, it simply does not work. I have googled and googled but cannot find any other people using Xamarin and this. Thanks for your time. Seth On Thu, May 12, 2022 at 6:19 PM Seth Isaacks ***@***.***> wrote:

…

Something just occurred to me, I have been turning change tracking on for the entire server database...should I only be doing that per table? Just trying to figure out why I am getting the errors I am getting. On Thu, May 12, 2022 at 5:39 PM Seth Isaacks < ***@***.***> wrote: > IN the migration sample you have, if I run your example on the mobile > side I get an exception stating: > > {System.PlatformNotSupportedException: > Strings.PlatformNotSupported_DataSqlClient > at Microsoft.Data.SqlClient.SqlConnectionStringBuilder..ctor > (System.String connectionString) [0x00006] in > /_/artifacts/Project/obj/Release.AnyCPU/Microsoft.Data.SqlClient/netcore/Microsoft.Data.SqlClient.notsupported.cs:504 > > at Dotmim.Sync.SqlServer.SqlSyncProvider..ctor (System.String > connectionString) [0x00021] in <aa4426aee7564ab09ad93bdbfadb609f>:0 > at AutomobileApp.Services.NFODataService.Test () [0x0008e] in > C:\SandBox\AutomobileApp\AutomobileApp\AutomobileApp\Services\NFODataService.cs:191 > } > > On Thu, May 12, 2022 at 4:43 PM Seth Isaacks < > ***@***.***> wrote: > >> I am not sure what else to do, I have done everything your >> directions say to do but it will not work. >> Instead of doing the migration, I added the new column as per your >> example. >> I then ran just the web api...by pressing PLAY on the project. >> Then I checked the azure database to make sure it updated which it did. >> Then I went back to my mobile app and ran the app and updated the Sqlite >> Database per your instructions. >> Then I tried to sync the data and I get the same error again. >> Without someone help that is more knowledgeable, it does not appear it >> will work with Xamarin and Sqlite >> >> Regards >> Seth Isaacks >> >> On Thu, May 12, 2022 at 3:29 PM Seth Isaacks < >> ***@***.***> wrote: >> >>> Tables after migration >>> >>> [image: image.png] >>> >>> On Thu, May 12, 2022 at 2:36 PM Seth Isaacks < >>> ***@***.***> wrote: >>> >>>> Here are my tables before the migration...essentially the very first >>>> sync >>>> >>>> [image: image.png] >>>> >>>> On Thu, May 12, 2022 at 2:32 PM Seth Isaacks < >>>> ***@***.***> wrote: >>>> >>>>> Hmmm all i did was an EF migration, not sure how that would have been >>>>> deleted? >>>>> So its a server issue not the local sqlite database? >>>>> For the EF migration, I used visual studio package manager console >>>>> Then I ran the code for the server in the web api, everything seemed >>>>> to update correctly. >>>>> I didnt see a tracking table before or after on the server. Where >>>>> would the tracking table be? >>>>> I spoke to my boss, he said if you have the time to help with this, >>>>> we will pay. >>>>> >>>>> Seth >>>>> >>>>> On Thu, May 12, 2022 at 2:21 PM Sébastien Pertus < >>>>> ***@***.***> wrote: >>>>> >>>>>> Seems you have deleted the tracking table on your server >>>>>> >>>>>> — >>>>>> Reply to this email directly, view it on GitHub >>>>>> <#734 (reply in thread)>, >>>>>> or unsubscribe >>>>>> <https://github.com/notifications/unsubscribe-auth/AOZ5VYFUUMIKXTXAGTJOEQDVJVY6VANCNFSM5VWHRNCA> >>>>>> . >>>>>> You are receiving this because you authored the thread.Message ID: >>>>>> ***@***.*** >>>>>> com> >>>>>> >>>>>

[Mimetis]

I do not believe DotmimSync will work with Xamarin and Sqlite.

You have a sample in the repository using Xamarin and Sqlite

but there is not a Vehicle_Tracking

If you want to sync a Vehicle table, DMS will create automatically a Vehicle_tracking table
If the table does not exist anymore, maybe you have drop it or rename or whatever and DMS does not check every time if the tracking tables are still existing.

I have followed your online examples on github for migration, it simply does not work.

You have to be a little bit more explicit to help me figure it out. If you want any help, please provide a sample code to work on
Regarding migration, you have everything in the docs

[sisaacks]

Tables after migration [image: image.png] On Thu, May 12, 2022 at 2:36 PM Seth Isaacks ***@***.***> wrote:

…

Here are my tables before the migration...essentially the very first sync [image: image.png] On Thu, May 12, 2022 at 2:32 PM Seth Isaacks < ***@***.***> wrote: > Hmmm all i did was an EF migration, not sure how that would have been > deleted? > So its a server issue not the local sqlite database? > For the EF migration, I used visual studio package manager console > Then I ran the code for the server in the web api, everything seemed to > update correctly. > I didnt see a tracking table before or after on the server. Where would > the tracking table be? > I spoke to my boss, he said if you have the time to help with this, we > will pay. > > Seth > > On Thu, May 12, 2022 at 2:21 PM Sébastien Pertus < > ***@***.***> wrote: > >> Seems you have deleted the tracking table on your server >> >> — >> Reply to this email directly, view it on GitHub >> <#734 (reply in thread)>, >> or unsubscribe >> <https://github.com/notifications/unsubscribe-auth/AOZ5VYFUUMIKXTXAGTJOEQDVJVY6VANCNFSM5VWHRNCA> >> . >> You are receiving this because you authored the thread.Message ID: >> ***@***.***> >> >

[sisaacks]

IN the migration sample you have, if I run your example on the mobile side I get an exception stating: {System.PlatformNotSupportedException: Strings.PlatformNotSupported_DataSqlClient at Microsoft.Data.SqlClient.SqlConnectionStringBuilder..ctor (System.String connectionString) [0x00006] in /_/artifacts/Project/obj/Release.AnyCPU/Microsoft.Data.SqlClient/netcore/Microsoft.Data.SqlClient.notsupported.cs:504 at Dotmim.Sync.SqlServer.SqlSyncProvider..ctor (System.String connectionString) [0x00021] in <aa4426aee7564ab09ad93bdbfadb609f>:0 at AutomobileApp.Services.NFODataService.Test () [0x0008e] in C:\SandBox\AutomobileApp\AutomobileApp\AutomobileApp\Services\NFODataService.cs:191 } On Thu, May 12, 2022 at 4:43 PM Seth Isaacks ***@***.***> wrote:

…

I am not sure what else to do, I have done everything your directions say to do but it will not work. Instead of doing the migration, I added the new column as per your example. I then ran just the web api...by pressing PLAY on the project. Then I checked the azure database to make sure it updated which it did. Then I went back to my mobile app and ran the app and updated the Sqlite Database per your instructions. Then I tried to sync the data and I get the same error again. Without someone help that is more knowledgeable, it does not appear it will work with Xamarin and Sqlite Regards Seth Isaacks On Thu, May 12, 2022 at 3:29 PM Seth Isaacks < ***@***.***> wrote: > Tables after migration > > [image: image.png] > > On Thu, May 12, 2022 at 2:36 PM Seth Isaacks < > ***@***.***> wrote: > >> Here are my tables before the migration...essentially the very first sync >> >> [image: image.png] >> >> On Thu, May 12, 2022 at 2:32 PM Seth Isaacks < >> ***@***.***> wrote: >> >>> Hmmm all i did was an EF migration, not sure how that would have been >>> deleted? >>> So its a server issue not the local sqlite database? >>> For the EF migration, I used visual studio package manager console >>> Then I ran the code for the server in the web api, everything seemed to >>> update correctly. >>> I didnt see a tracking table before or after on the server. Where >>> would the tracking table be? >>> I spoke to my boss, he said if you have the time to help with this, we >>> will pay. >>> >>> Seth >>> >>> On Thu, May 12, 2022 at 2:21 PM Sébastien Pertus < >>> ***@***.***> wrote: >>> >>>> Seems you have deleted the tracking table on your server >>>> >>>> — >>>> Reply to this email directly, view it on GitHub >>>> <#734 (reply in thread)>, >>>> or unsubscribe >>>> <https://github.com/notifications/unsubscribe-auth/AOZ5VYFUUMIKXTXAGTJOEQDVJVY6VANCNFSM5VWHRNCA> >>>> . >>>> You are receiving this because you authored the thread.Message ID: >>>> ***@***.***> >>>> >>>

[Mimetis]

Sql Server is not available on xamarin,
Consider using sqlite instead