I have some recommends here:

1-Choose the point time when your server does not work hard

2-Separate your table into smaller pieces (may be multiple files) and using a package to transform data