I have an employee table in two different servers with the same structure. I want to shift all the data to main server but there are some records already exists in main server that are duplicate of local one's but are incomplete, now i want to compare these records so i can chose the most completed one and delete the incomplete one from one of the servers. surely i will use dblink to compare but what would be the SQL query for it?
in short some of the records are incomplete in local server while some of them are incomplete in main. is there any way to compare them and chose the completest one?
Thank you in advance.