Need to convert MS SQL Server to Oracle or Oracle to MSSQL then, you have to come to right place. Our tool can convert databases in just few mouse clicks. No need to write a single piece of code. It automatically convert tables, schemas, constraints, default values and of course data.
It can also load data into existing tables with full column mapping
support. Unlike other tools which just creates and loads data into new
tables, Data Loader can be use to load data into existing tables with
different table names and column names.
it comes with it's own scheduler to perform conversion jobs automatically at your specified intervals. You just need to create a Session define the execution Date and Time interval and Data Loader will automatically executes your session in the background and records the actions in a specified logfile.
Data Loader migrates Constraints and Indexes. It can migrate Primary Keys, Unique Keys, Foreign Keys, NOT NULL and Default Values.
Data Loader also supports BULK INSERT and BULK LOAD methods to load data into MS SQL Server and Oracle databases. This method greatly improves the performance and one can load millions of rows in very less time.
Basic conversion can be done in simple steps
And as usual Data Loader comes with it's own in built Scheduler. No need to run jobs repeatedly. Just start a Session define the Schedule Date and Time and Data Loader will automatically executes your session in the background and records the actions in a specified logfile. You can check the logfile to check the result.
The Data Loader uses Repository to Store Sessions. It provides Options to Create a new repository in case the current repository has become damaged or lost, to take backup of existing Repository and to restore repository from a backup location.
You can manage existing sessions through Manage Sessions Form. From here you can the see the Status of existing sessions, Edit, Run, Delete or View Logfile of individual Sessions.