Today in the SQL Server into SQLite database, encountered a lot of problems, searched the internet for a long time, did not find the right software to convert SQL Server to SQLite, which used the Sqlitedev software, in the process of conversion, If you have a problem with your watch, then you can't convert it all, but you have to continue to search for the conversion software on the Web, and finally find a perfect, very simple and useful software. First share to everyone:
1. In 1, enter the server address name of SQL Server, after input completes, click Set, will come out Select database (select db), the user can select the database that you want to convert
2. In 2, if the connection database has a password, you need to remove the integrated front check, enter the connection database user name and password
3. In 3, enter the file path and filename converted to SQLite
4. Click here to start the conversion.
The advantages of using the software: The software is downloaded from the Foreigner's website, is a program written in C #, is open source, you can go here to download: http://www.codeproject.com/KB/database/ Convsqlservertosqlite.aspx can download the entire compiled program, you can also download the compiled debug program, the function is very powerful, dozens of your database has a little error, can also help you achieve conversion.