Kapalı

Automate Oracle Database restore (form DMP file) to public database in non-oracle format

Every day an Oracle database is backed up (in .DMP format) and is posted to a public FTP folder in compressed RAR format ([url removed, login to view]).

I need your help developing an automated daily script that does the following:

1. Uncompress the RAR file

2. Opens the .DMP file

3. Gets all the database structure and data and restores it into a cloud and not expensive database type (like mysql)

-->Everyday the mysql-type database should fully be replaced with the structure and DATA of the .DMP file.

----

The issue is that I do not have an Oracle license and I would like to be able to make any kind of queries of what's inside the DMP file without paying for an expensive oracle license.

Solution must be in the cloud, as I plan to connect Zoho Reports to mysql database (or whatever Databse type is chosen)

Beceriler: Veri Tabanı Yönetimi, Veritabanı Geliştirme, Veritabanı Programlama, Oracle, SQL

Daha fazlasını gör: need oracle dump file, export dmp file oracle mysql, import dmp file oracle unix, data_pump_dir location, oracle dump file location, data pump directory location in oracle 11g, oracle data pump directory location, shell script to connect to oracle database in linux, how to check data pump directory in oracle, oracle shell scripting tutorial, how to change data pump directory location, convert oracle dmp file excel, oracle backup restore, conver mssql bak file oracle dmp file, database form standalone file, restore quickbooks mac backup file online, access database form exe file, database dmp file wikipedia, read mssql backup file, restore moodle bid file

İşveren Hakkında:
( 1 değerlendirme ) Bogota, Colombia

Proje NO: #16594015

Bu iş için 12 freelancer ortalamada $500 teklif veriyor

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
5.3
acronymsolutions

Hi, I have gone through your requirements. I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle ,Sybase (12.5) ,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards, MySQL Daha Fazla

in %bids___i_period_sub_35% gün içinde561%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(41 Değerlendirme)
5.7
mdo19

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
3.8
heyraam86

I have been working as an Oracle DBA - Team Lead and having 6 years of very good experience in Oracle core dba activities like implementing RAC with ASM,Configuring Data Guard, Migrating database across platforms and u Daha Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.8
pratikgedia

Hello, Hope you are doing well. Could we please have a discussion on it? As in which cloud are you using, is this full schema import and rest ? Thanks, Pratik Gedia

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.3
in %bids___i_period_sub_35% gün içinde666%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.5
aspelsit

I am an IT Consultant with over 8 years experience involving database administration, system analysis and software development. My expertise ranges from database design, data migration, performance tuning and administ Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
softechlab

hello. i am interest in your project. i have enough skills for your project. However, because the specification is so brief, if I know specifically about your needs, I can do it at a high level in the near future. Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
zahid6288

I am a database developer. I can solve your problem in most systematic way. Relevant Skills and Experience Database Oracle developer and designer. having full and strong command on Sql, sql plus form builder etc

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
gsystemas

Gsystemas Oracle Expertos , mas de 25 años en Bases de datos relacionales, NoSQL y Bases de datos biologicas y Bases de Datos Cloud . Le podemos proporcionar infraestructura Oracle Cloud ,Azzure o Google cloud, de form Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
ganagnos

We are planning to use an intermediate server for data migration to the final mysql. We have allready used such approach for several another customers. Looking forward to hear from you.

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0