Deleting 1 million records in a DB, what are my options?

Need help Database
1

Hello,

I have two data types

Student
Student Information - Contains a field called Student which is of type Student.

There was an issue earlier where a CSV file was uploaded to the student database, so there are over 1 million rows, but only about 15k of them are needed, the rest are empty.

The problem is, We have several student information records that are linked to the Student. If I delete the Student data type, the link from the Student Information table to the student would be deleted.

Any ideas how to remove all the empty DB records while preserving the link from Student Information to Student?

I don’t have another version on dev without these empty records

2

create a bulk action to automate the deleting of values but not remove the linking

3

Do you have a plan that let’s you revert to the way your db was a few days ago?