This is a tool that helps importing Oracle data to MS SQL database.
DBA and programmers who need to work with both Oracle and MS SQL database in the same shop and need to transfer data from Oracle to the SQL server database could make use of this tool. The interface is simple. You could set it up very easily too. Even the newest recruit into the IT department could handle this routine well. The configuration of the tool is visual. Source and destination database could be easily set up. The destination connection will be tested. Saving and loading parameters of each session will be preserved so that next time for similar transfers nothing further needs to be done. The progress of transfers can be monitored easily o the progress bar. It shows number of records transferred in addition. The interface wizard is a further help in guiding users through the motions.
Source table and elements to be used for the transfer and the mapping to the destination can be easily set up through mouse clicks. Data harvesting from the source could be done through queries too. Multiple transfers to the destination are possible. With Unicode support database records can contain text in any language; there should not be any problems. Command line mode and scheduled modes of transfers make the tool even easier to use. Command line mode is really for the convenience of experienced users. Scheduled mode works automatically and makes everything quite simple. This is a very good utility that could be useful on a regular basis.