
Need mysql script to transform/alter/populate DB schema
- or -
Post a project like this1483
$100
- Posted:
- Proposals: 1
- Remote
- #3194529
- Awarded
Description
Experience Level: Entry
Estimated project duration: 1 day or less
We have a working application hosted on production server. Application is made is Spring Boot and Hibernate as ORM. As part of improvements, I did lot of changes on QA server resulting in many new fields being added (some nullable while some are not). Also, I didn't kept track of changes. Now, to promote this code to production, I need both old and new schemas to be same. So, I need some one who can write advanced mysql script to do the transformation. I will provide default value for data that is non-nullable. No of tables to be modified - ~20 Amount of changes to each table - very minimal. Not more than 4 fields are added to any table DB Hosted - Yes. DB is hosted on cloud. If you want to work on local, I can provide data dump. What is expected - A MYSQL DB Script, executing which will transform my existing production schema structure to QA structure with all non-nullable fields pre-populated.

Sridhar P.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
20%
Last project
15 Mar 2021
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies