Transferring WordPress Instances

You need change URLs in the complete database, not just in the two tables in wp_options. See WordPress Serialized PHP Search Replace Tool | Interconnect and the docs at Moving WordPress « WordPress Codex

Sync Local site and Distant site

It sounds like you need to update the database to replace the guids and base URL. I recommend WP Migrate DB Pro to quickly sync two databases. Otherwise you need to run a few SQL statements to find and replace the old domain with the new domain. In PHPMyAdmin run the following statements from the … Read more