Configuring Dbvisit Replicate for the replication from Oracle to MSSQL starts with executing "setup wizard" command on Dbvisit Replicate command console. Setup wizard generates the required commands to configure the environment and start the replication. The wizard also creates the necessary scripts to create the Dbvisit Replicate schema owner, grant the necessary privileges and create the environment (DDC) file. The setup wizard can be used as a starting point and then the configuration files can be edited to create more complex replications.
When source and target Databases are running on Windows OS, the setup wizard is executed on the source system.Whereas when the source system is Linux the setup wizards must be executed on the target Windows system.Furthermore the setup wizard interacts with an MSSQL target database through DSN, which requires an ODBC driver.ODBC drivers for Linux have been released by Microsoft but Dbvisit Replicate currently does not support them.
A future release of Dbvisit Replicate will support these ODBC drivers for Linux, which will allow execution of the setup wizard on Linux for MSSQL replication.
Please refer to following examples for replication from WIndows to Windows and Linux to Windows.