Is the content overwritten on the remote server?

YES! The remote document root files will be replaced by the new document root files you are transferring. Remember to backup all your files (document root & databases) before starting a transfer.