I am planning to setup snapshot replication and transaction replication from sql server to oracle server, in the process of doing such replication, there are a bunch of files stored at file directories for replication, what is the best practice to housekeep these files?
Also, do I need to use enterprise version sql server in order to replicate data from sql server to oracle?