Dbvisit Replicate can automatically instantiate the data before the replication starts. The Replicate Load functionality works for the following target databases:
- Oracle
- SQL Server
- MySQL
The Replicate Load functionality is completely automatic and ensures that the tables are created on the target before the load begins. It takes care of the different data types between the databases for all supported data types.
In section 2 of the Setup Wizard there is a question about what data instantiation script to create. One of the choices available is called 'load'. The option for load will not create a script. A second question will be asked regarding if you want to keep the table on the target or create it anew. By choosing this method Replicate will automatically load the data when you start up the MINE process and APPLY process, no export/import or additional scripts are needed.
...