Transfer data from SQL Server to Sqlite with Android

Asked

Viewed 471 times

0

I have a software that is connected to an SQL Server database, but now I am making the software on Android using Sqlite.

I need to transfer the SQL Server database (with the data) to my Sqlite.

Backup works? Even with the views I have on SQL Server? What is the way I can do this?

1 answer

3


If you use the SQL Studio just right click on the database you want to copy the data if you select Tasks > Generate Scripts.... Fill in the information until the screen Set Scripting Options and click on Advanced. Change the option Types of data to script for Data only (You will need to create tables with the same structure on SQLite). Fill in the rest of the options on the other screens and the script will be created. Then you just need to run it on SQLite.

Opções

Avançadas

Browser other questions tagged

You are not signed in. Login or sign up in order to post.