Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
We use ruby scripts to migrate data from MySQL to Redshift(PostgreSQL).Currently we use YAML configuration files to maintain schema information (column names and types).So whenever a MySQL table is altered, we need to manually change the YAML files.Now, we are thinking of moving YAML configurations to database(PSQL) as JSON object. But still we need to manually change the schema configurations.We want to automate the process.(Preferably using Ruby.)

PS: We use bin-log to incrementally update data in AWS Redshift.


What I have tried:

We have moved YAML files to db(MySQL) and provided a UI to directly update files and update db.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900