...
The replication has been configured and installed. Steps required to start replication are saved in Nextsteps.txt file.
| Note |
|---|
Apply.sql file contains script for creating tables in MSSQL. Copy that script and execute in MSSQL. It will create tables in MSSQL, you can later load initial data from oracle to MSSQL. If you already have source and target database with identical data then you can ignore this step. You can still crosscheck MSSQL columns datatype from this script as APPLY.sql is generated by Dbvisit Replicate, It contains perfect datatype matching from oracle to MSSQLOtherwise, If you have empty source tables then you can execute APPLY.sql to create tables in SQL server. You can also use SQL Server Migration Assistant for Oracle to create tables and then load data into SQL server. |
| Note |
|---|
Executing reptest2-all.bat script creates dbvrep database in MSSQL to store metadata of replication. Set correct snapshot isolation for dbvrep. Click here for more info. |
...