What is the best way for me to run a data migration script in production?

My local development is connected to my staging environment, so I can run this locally to see my changes. I can change the url to point to my database in production, but I was wondering if there is another better or more standard way of doing this. I only need to run this script once to migrate some data from one table to another.

Thanks