>Why not look at merge replication, rda or sync framework, all three will do this...
Will replication allows me to do that on request? I do not want something automatic. This is a procedure that I need to do at several occasions, when needed, so I can synchronize a table on a DEV server, for example, from the production environment.