How can one sync between MSSQL and SqLite

[Vuminkosi]

I need to sync between Sql database and Sqlite local Cache file

[RohitM-IN]

which way it is from MSSQL to SQLite or other way around ?

its possible to do so if the interface for SQLite is implemented if you want to convert from MSSQL to SQLite

Edit: also I may have partial implementation for SQLite its just that only data sync is possible as our future plans are to make schema sync possible too but for SQLite we gave up on that part still give me this sat & sun I will update my old implementation and publish the NuGet package

@Psychac share some light on metadata sync if its possible to make the schema sync part we may have discussed this I will open another discussion for this lets talk there

ref: DbSyncKit/DbSyncKit#22

[RohitM-IN]

I recommend you check feature/SQLite branch I have added my old code which surprisingly didn't break the code and passed my test for getting same amount of changes compared to other still I will do some more testing on sat

[RohitM-IN]

The package has been added to NuGet DbSyncKit.SQLite

you can use

IDatabase SourceDatabase = new DbSyncKit.MSSQL.Connection("(localdb)\\MSSQLLocalDB", true, "SourceChinook");
IDatabase DestinationDatabase = new DbSyncKit.SQLite.Connection(Path.Combine("Path", "to", "destinationChinook.sqlite"));

checkout the Cross DB Migration doc here

[RohitM-IN]

@Vuminkosi let me know if you face any issues with queries that the package generates