CODEWITHSUNDEEP
androidsql-serverdatabasesql-server-2008sqlite
jason
jason

Reputation: 7164

How to turn an MSSQL database to SQLite database for Android

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.

Upvotes: 6

Views: 4435

Answers (2)

hafiz mohammad Danmanu
hafiz mohammad Danmanu

Reputation: 40

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

Upvotes: 0

Ashraf
Ashraf

Reputation: 3192

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

Upvotes: 5

Related Questions