There are manily two major prerequisites for the Oracle to MSSQL 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 Data Source Name(DSN) configured with the same name on both source and target systems.