I have software that is connected to a SQL Server database, but now I'm doing the software on Android using SQLite.
I need to transfer the SQL Server database (with data) to my SQLite.
Backup works? Even with the views I have in SQL Server? What is the way I can do this?
If you use SQL Studio , you only have to right-click on the base you want to copy the data to if you select Tasks > Generate Scripts... . Fill in the information up to Set Scripting Options screen and click Advanced . Change the option Types of data to script to Data only (You will need to create tables with the same structure in SQLite ). Fill in the rest of the options in the other screens and script will be created. So you just have to run it on SQLite .
