Migration from MySQL or use thereof?
Hi All,
This may be a strange question.
I am learning ASH and Phoenix which are excellent.
I've played with MyXQL however I know Ash is Postgres driven.
Here's the question,
If I port my data over to Postgres is there an easy way to "reverse" migrate the DSL from MySQL :thinkies: ?
It is possible to migrate your data from mysql to postgres, could I just create the resources in the same schema/layout and party?
Safely ignore the question if it's nonsense 👾
Thanks,
Carl
4 Replies
If you don't use any MySQL specific Features it should be fairly straightforward. You could just create your resources and let ash create the postgres schema. Afterwards export your data from MySQL as SQL inserts and just insert the data into postgres.
GitHub
GitHub - dimitri/pgloader: Migrate to PostgreSQL in a single command!
Migrate to PostgreSQL in a single command! Contribute to dimitri/pgloader development by creating an account on GitHub.
Pgloader might also be helpful to migrate the data
Most Excellent.
Thank you so much, I'll give that a whirl.