>>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.

It can be scheduled or manual... your choice.