How to turn an MSSQL database into a SQLite database for Android

Question

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

Answer 1

You can try DBConvert

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

DBConvert for SQLite and MSSQL

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

DBSync for SQLite and MSSQL

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