WordPress redirect on login

I think getting the site to redirect to the proper location on login would only be the beginning of your issues with this setup.

What would happen when you want to use any WordPress function to retrieve the site url? You would possibly have to re-write those functions as well, so that they return the production url instead of the url from the database.

If your production site is on your local machine you might try editing your HOSTS file so that your local machine thinks that its the real server. When you are finished working on your local machine you could then switch your hosts file back to normal to see the real live site again.

Check this URL http://wpmututorials.com/how-to/using-a-hosts-file/ for more info on using a hosts file.