It depends on the DBMS you are using, but you can get some ideas from Remote MySQL table comparison. It can get you started on the general principles.