Convert Access to SQLite Database

SQLite is a lightweight database. It is suitable for small websites because of Access! Today, I decided to switch the system database from Access to SQLite. I searched the internet and found the DBManager tool. I have to say that this software is really good and powerful. I also found a registration code on the Internet for half a day and could not find one! Only

SQLite is a lightweight database. It is suitable for small websites because of Access! Today, I decided to switch the system database from Access to SQLite. I searched the internet and found the DBManager tool. I have to say that this software is really good and powerful. I also found a registration code on the Internet for half a day and could not find one! Only

SQLite is a lightweight database. It is suitable for small websites because of Access! Today, I decided to switch the system database from Access to SQLite. I searched the internet and found the DBManager tool. I have to say that this software is really good and powerful. I also found a registration code on the Internet for half a day and could not find one!

You only need to convert Access to SQLite, and then use System. Data. SQLite. dll to Access the database. We use DbManager to create an SQLite database.

For example:

2. Select data and click "Tools"> "Data Management"> "import data ".

3. Select the Access and mdb files according to the wizard, and select the file location. All the tables in the Access database will be listed. Select All Tables and include data

4. Click "OK" to start importing data. After the import is complete, open the table and check that it is exactly the same as the original data!

The Database Import has been completed. We can use this SQLite database in our project!

Unfortunately, when reading SQLite, an error is reported:

File opened that is not a database file
File is encrypted or is not a database

When you use SQLiteSpy to open the SQLite database, you are prompted to enter the password.

I just spent one afternoon on this issue. I said that the database was damaged on the Internet, and some said that the password was set for the connection string.

After thinking over and over again, I think the problem should be solved in the SQLite version. I can only convert Access to SQLite in other ways.

Fortunately, the database supports SQL. I only try to export data as an SQL file, and then create a file through SQLiteSpy that supports ASP. Net calls. Execute the script in this file!

The result is finally settled!

DBManager also supports exporting SQLite data to an SQL file: select database> Dump and follow the export script

After the script is exported, we can use SQLiteSpy to create a New DataBase: File-> New DataBase

After the creation is complete, execute the saved SQL script.

Now, you can put this database file in our project for System. Data. SQLite. dll to call!

By: (www. ops. cc) Obo Network