MSSQL2Oracle is a small migration tool to help you migrate to Oracle database. It extracts basic database structure and all of the data from source SQL Server database. All the data is written to files, one file for table structure and one file per table.
- Translate all camel case table and column names to upper and underscore delimiter
- Create a file with SQL create statements (FK, indexes not supported for now)
- Create files with SQL INSERT statements from the SQL Server source database
The easiest way is to download compiled zip version from the url, or download the latest version of the source and compile it yourself.
- If obtained the zip, extract it
- Navigate to application through command promt (you may need to run it in admin mode)
- Run the app with params
- c - Source SQL Server connection string inside quotes
- p - full path to directory where you want the data to be stored