6

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.

jason
  • 6,962
  • 36
  • 117
  • 198
  • 1
    You could... **1** use the MySQL db through a webservice. OR **2** Export your MySQL db to a common format (probably, a serie of CSV files - 1 per table), then re-import it into SQLite (you'll have to remake the indexes, the keys, ...) – Phantômaxx Aug 20 '15 at 11:04

2 Answers2

5

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
Ashraf
  • 3,114
  • 3
  • 23
  • 22
  • 1
    Thanks for your reply. Could you also tell me how to extract the database from SQL using Management Console? – jason Aug 20 '15 at 11:23
0

You can convert the dB using dbmigration to any type you want You just need select the source database and destination type you want then Good to Go Follow the below link to download https://download.cnet.com/dbMigration-NET/3000-10254_4-76452016.html

hafiz mohammad Danmanu
  • 20
  • 4