i need to do this:
simulate a replication but with some particular rules like examples:
- some table won't add always they will check if the value exist and if so it won't do nothing
- some table need to check first if there is some value in other table. if so then it'll make the operation indicated
- some table if the value exist won't do anything
- some table if the value exist will update
and
many other rules. there is some way that i can do this? all this is
between SQLServer 2012 of course and also that this operation will be
execute like a task, at an specific time of the day and every day.
thanks.