How to convert a backup SQLServer database to an SQLite Database

Operation Method: first install SQLServer2005, and remember the user name and password you set during installation. The following describes how to restore the database file epdmdb20101008.bak backed up by SQLServer as an example.

① Open SQLServer2005, as shown in:

Enter the login name and password on the logon page and click "Connect ".

The logon interface is as follows:

② Create a database.

Right-click the database in the left navigation bar and choose create database, as shown in:

In the new database window that appears, enter "Database Name" and click "add ". Click OK after the successful addition. Note: The database name must be a combination of English letters and numbers and cannot contain Chinese characters.

After the database is successfully added, the name of the newly added database is displayed in the lower navigation bar on the left. Add a database named epdm003, as shown in:

③ Select this database, right-click Task-restore-database, and the Restore database window is displayed, as shown in:

④ In the Restore database window, select the database backed up under SQLServer to import data from SQLServer database to epdm003.

In the "Restore database" window, in "Restore target", "target database" is the selected epdm003, "Restore source", select "source device", and click "Browse, select the database to be backed up under SQLServer. As shown in:

Click "OK". In this way, the database file backed up under SQLServer is displayed after "Source Device" in the Restore database window. In this case, check the record under "select backup set for restoration", as shown in:

Click "options" on the left to bring up the option interface, as shown in:

Check "Overwrite existing database" under "Restore options" in this window, and select "Restore status" from "first. Click "OK ". As shown in:

When the prompt is displayed, the data in the database file backed up under SQLServer has been restored to the epdm003 database.

⑤ Recover data from the epdm003 database to the current database connected to EI5.0.

First, make sure that the 5.0 software is installed on the local machine and can be logged on normally. If there is data in the 5.0 software, back up 5.0 of the data first. The next step is to recover the data in the epdm003 database to the 5.0 software, which will overwrite the data in the current 5.0 software. 5.0 after the current database is backed up, perform the following operations:

Click "start"-"program"-"build industry management information system (Survey and Design Enterprise Edition)" 5.0-the old EI Database migration tool will pop up the window for the old EI Database migration tool, as shown in:

In this window, click "select SQLServer Database". The following window is displayed for data source import:

In the window shown in, change "server" to "point" in the English input method. "," Database ", fill in" epdm003 "," User Name "and" password ", fill in the username and password you set when installing SQLServer2005, and then click" OK ". As shown in:

After confirming, you will return to the old EI Database Import window. Then, click "import data" and the data below will start to scroll, indicating that the data in epdm003 is being imported to the database currently connected to EI5.0. As shown in:

After the data is imported, the following message is displayed: "NOTE: the passwords of all logon users are automatically cleared in the new system. Modify the logon password after successful logon, thank you! Data Import ends ".

6. After the data is imported, find the database currently connected to EI5.0. This database is the SQLite database after the SQL Server database is restored to the SQLite database.

Where is the database currently connected to EI5.0? You can find it as follows:

Start the 5.0 software. When the logon window is displayed, click "database Settings" in the logon window to bring up the database settings window, as shown in:

The path behind the "SQLite file" field in the window shown in is the path of the database currently connected to the EI5.0 software. The last epdmdb. db in this path is the database file of the 5.0 software. Find the file in this path.

So far, all the operations for converting SQL Server database to SQLite database have been completed.