Fermé

Python scripting for data migration from one database to another database

we are working on writing on python scripts to connect to the Snow-flake database and extract the required data from there and insert the data in the Postgres database.

As part of this work, I need to write logic in the python related to how we should insert or update data in the postgres tables

*********SBB Data load logic swap requirement********

We have 7 tables in total, 6 load tables and one lookup table

We need to make changes in the existing python script, regarding the logic how we load data in the tables (postgres) and also the status for 4 days.

Day1:

We insert the data and the status will be “Active”.

“Only insert”

Day2:

First, we insert the data with status as “Inactive” for the current day, then we update the status for Day1 as “Inactive” and finally for current day updated status will be “Active”.

“Insert, Update, Update”

Day3:

We update the day1 data status as “Active” and Day2 data status as “Inactive”.

“Update, Update”

Day4:

We update the day1 data status as “Inactive” and Day2 data status as “Active”.

“Update, Update”

Compétences : Python, SQL

en voir plus : screen data grabber database, excel data access database, export data excel database java, how to transfer data from one database to another database in oracle, how to transfer data from one database to another database in sql server using ssis, python database migrations, python copy data from one database to another, how to insert data from one database table to another database table in sql server, how to copy data from one server to another in sql server, data migration using python, how to transfer data from one database to another database in sql server, macro move data cell database excel, php query data access database, calling data sql database web service, richfaces edit table data save database inplaceinput, using struts data oracle database jsp struts, input excel data access database, send data ivr database asterisk, send form data mysql database using php, save data xml database flash cs3

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #18990461

20 freelance font une offre moyenne de $161 pour ce travail

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(29 Commentaires)
6.0
brianconey

Hello How are you I have read your job description in detail . I am Xu It is a piece of cake Please contact me and Let's discuss more thanks for your posting . hope to hear from you .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(13 Commentaires)
5.5
kipdev13

Hi, Dear! I`m great interested in your suggest. If you're interested - contact me. Let's get in touch to discuss your project in more detail via here. It would be great to discuss details to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(42 Commentaires)
5.5
polarjin2017

Hello? How are you? I have seen the project - "Python scripting for data migration from one database to another database." I have been working in these fields((Python, SQL)) for 7 yrs as a freelancer. I can work f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(20 Commentaires)
5.3
muller1998926

Hello, dear! I am interested in your project. I have extensive experience in Python/MySQL. As a developer with rich experience, I am confident about your project. I will provide perfect results in a short time. If Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
4.2
seemasit

Hi there, I've gone through the post description carefully and ready to start work on this project. Requirements are very clear but please come over the chat so that i can get more requirements if remaining. I am Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
4.7
KongHyanJa

Dear Client!!. I'm an expert of programming Thank you for your attention I am a Programmer with 7 years of experience in full circle of software development. I am interesting in Python and Statistics,Web Scrap Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
3.3
alexwmsoft

Hi there, I am an experienced website developer, and I have 5 years experience in developing websites using HTML, CSS and PHP and several frameworks such as Wordpress, ASP.NET, Laravel, Codigniter, django and so on Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
3.0
susanna2018

Hi, Sir!!, Please give me your site url that you want to crawl. @$@$@$PLEASE CONTACT ME. I CAN DO IT IN 1 DAY $@$@$@ ##% Your idea is attracted me to your world. %## i use python selenium and beautiful soup for s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
3.2
aifisolutions

We specialize and have 20 years of experience in Desktop/Web/Mobile application development. We provide our expert service in the following areas: • Artificial Intelligence • Automation Solutions • Data Science • Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)
3.2
hanmingxue95

Hello. I can do your project using python sqlite3 library. This library is suit for RD management. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
3.0
harikumarln23

Hi, I have 7 years of professional experience in SQL design & development, Python development and automation. I can help you accomplish your task. Please feel free to discuss with me about the project. Thanks, Hari

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
2.3
bkaganozkan

I'm study on computer science. I can handle that easily with ORM it's safe and practical for you. I'm experienced for +2 years with Python. We can discuss all the detail on chat.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
1.7
leadermalang

Hi, Hope my message finds you well. I have more than four years experience working as full stack python developer.I have hands on experience with python and postgres database.I had used postgres database with [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)
0.9
mohanraj0201

Do you have a C and Python job and are looking for a talented and experienced C Programming and Python Developer? I believe that my experience and skill in this background will prove to be of great help to you. I have Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
estebansalpeter

Hello, I'm an experienced developer and I'll be glad to help you with your project. You can see my portfolio and my pluralsight profile to check my proficiency in both python and sql. Feel free to contact me, I'll b Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
shenji108

Hello, how are you? I've read your description and I think I can give you the perfect result. I am a full stack developer and I have rich experience in Python and database. Please contact me. I will do my best Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
tko88

I have extensive knowledge of using Python and PostgreSQL for both personal and professional projects. I can help you write a script to do what you need done and also help you schedule it if needed etc.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
hollarblizexpert

I am very good in Machine Learning, Neural Networks, Python, Software Architecture, who consistently delivers great work on time, every time? That's exactly what I'll do for you. I've never missed a deadline and usuall Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Umiastos

Hello I have huge experience in work with tabels and downloading data from them. I creat many programs that searched the text or data from tables and database, for example in last week pulled out telephone numbers Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0