How to open million data in a bak file?

First, this bak file is a backup file of the SQL database. You need to use SQL to restore it and then you can query it.

Find the desired file

Note that the extracted data is 7 GB +

1. Download SQL server 2012 express (with Manager)

2. Install the "new installation"

3. Open SQL server management studio

4. Right-click the Red Circle "Database" ----- "Restore database"

Confirm import --- wait for completion

Then the database will appear.

Right-click to display the first 1000 rows.

You can see that the Code displays 1000 rows of information.

Then we will remove the top 1000

This turns out to be the case.

Then the most critical

Add at the bottom

Click "execute"

The following result is displayed:

I use ssd to search. It takes about 10 seconds to complete the search.