Data upload to 5 x Oracle tables required
Budget: $15 – $25 USD
I have 4 tables with sql scripts from MS SQL
I need them converting to Oracle, inserted and then exported to an oracle dmp file for single upload.
The data file formats available are csv or sql INSERT statements
Will estimate for around 1 hour per table.
Detail tasks
1. Create DDL for tables by convert MS SQL datatypes and syntax to Oracle tables
2. Create the oracle tables (developer will need their own 12c instance)
3. Convert sql data scripts (alternatively csv files are also provided for upload)
4. Load data into 5 x Oracle tables
5. Export 5 tables to .dmp file for importing to Oracle version 12c database
File share and files will be provided for successful candidate.
26252 records
317845 records
572 records
10779 records
134790 records
22 columns
4 columns
16 columns
15 columns
12 columns
I need them converting to Oracle, inserted and then exported to an oracle dmp file for single upload.
The data file formats available are csv or sql INSERT statements
Will estimate for around 1 hour per table.
Detail tasks
1. Create DDL for tables by convert MS SQL datatypes and syntax to Oracle tables
2. Create the oracle tables (developer will need their own 12c instance)
3. Convert sql data scripts (alternatively csv files are also provided for upload)
4. Load data into 5 x Oracle tables
5. Export 5 tables to .dmp file for importing to Oracle version 12c database
File share and files will be provided for successful candidate.
26252 records
317845 records
572 records
10779 records
134790 records
22 columns
4 columns
16 columns
15 columns
12 columns