Appending data to the existing database I've got a quick question , that would be great if anyone can help me with this problem: 
I have 2 SQL 2012 databases A &amp; B , they are both Identical same tables and same structures as well.
Data is inserted into DB A and on regular schedule I need the data to be inserted into DB B automatically and APPENDS to the existing data in DB B,after that, data in DB A gonna deleted and the whole process starts over again with new records.I couldn't preform this action using any methods of replication because once the data is deleted from DB A same thing gonna happen in DB B.
On the other hand these data contains FK pointing to other tables in the database so if the first problem solves and it starts APPENDING data to the existing data on DB B all these FK should be updated with new values in DB B.
Do you guys have any solution using SQL itself or any other tools?
You can use Transactional Replication, but you have to exclude the DELETEs. Just replicate INSERTs and UPDATEs.

Here's a related article.