How to turn an MSSQL database to SQLite database for Android

Question

I have an MSSQL database. I want to use it in an Android app. I apparently need to turn it to an SQLite database. How I can do that? All I can do in SQL is getting a .bak file which seems useless for my purpose so far. Can you tell me how I should get the database from Microsoft SQL Management Console and how I should add to my Android project? Thanks.

Answer 1

You can try DBConvert

https://dbconvert.com/sqlite/mssql/

DBConvert for SQLite & MSSQL

SQLite → MS SQL Server, MS SQL Dump
SQL Server → SQLite, MS SQL Dump
SQLite ↔ SQL Azure
SQLite ↔ Amazon RDS

DBSync for SQLite & MSSQL

SQLite ↔ Microsoft SQL Server
SQLite ↔ SQL Azure
SQLite ↔ Amazon RDS