There are two major prerequisites for the Oracle to SQL Server replication to take place. The first requirement is to have correct snapshot isolation of target database in order to avoid locking when replication takes place. Dbvisit Replicate also requires System Data Source Name(DSN) configured with the same name on both source and target systems.