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.


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

“Only insert”


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”


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

“Update, Update”


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

“Update, Update”

Skills: Python, SQL

See more: 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

About the Employer:
( 0 reviews ) United States

Project ID: #18990461

20 freelancers are bidding on average $161 for this job


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. More

$250 USD in 4 days
(29 Reviews)

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 .

$155 USD in 3 days
(13 Reviews)

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 More

$50 USD in 3 days
(42 Reviews)

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 More

$155 USD in 3 days
(20 Reviews)

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 More

$150 USD in 3 days
(4 Reviews)

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 More

$266 USD in 7 days
(3 Reviews)

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 More

$150 USD in 3 days
(9 Reviews)

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 More

$155 USD in 3 days
(2 Reviews)

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 More

$100 USD in 3 days
(4 Reviews)

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 • More

$300 USD in 10 days
(1 Review)

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

$55 USD in 3 days
(6 Reviews)

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

$166 USD in 3 days
(5 Reviews)

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.

$200 USD in 3 days
(2 Reviews)

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] More

$222 USD in 5 days
(1 Review)

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 More

$55 USD in 3 days
(0 Reviews)

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 More

$180 USD in 5 days
(0 Reviews)

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 More

$155 USD in 3 days
(0 Reviews)

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.

$250 USD in 5 days
(0 Reviews)

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 More

$155 USD in 1 day
(0 Reviews)

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 More

$55 USD in 4 days
(0 Reviews)