Are you planning to implement data migration?
Reported by taras | July 2nd, 2009 @ 02:51 AM | in v1.3.0
Hello Guiherme,
What are your thoughts on implementing data migration in addition to structure migration?
I'm currently using SQLyog Enterprise version which allows me to indicate 2 databases and it will give me an sql query that that would apply difference from source to target database.
I would like to replace this application with something that I can integrate into my command line/python based tools.
Would love to hear your opinion,
Thank you,
Taras
Comments and changes to this ticket
-
Guilherme Chapiewski July 27th, 2009 @ 06:26 PM
- State changed from “new” to “resolved”
- Milestone changed from “BACKLOG” to “v1.3.0”
Hi taras, sorry for not answering your message earlier.
If I understood correctly your question, simple-db-migrate already supports data migration. You can put ANY SQL you want in the migration files, including DML (INSERT, UPDATE, DELETE).
Besides that, you can also put Python code inside the migrations, because they are nothing more than 2 Python strings that are get by doing an exec() on the .migration file. It's pretty flexible for you to do any kind of database migration you want.
Regards, gc
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
simple-db-migrate is a database migration tool inpired on Rails migrations. For more info check the project website: http://guilhermechapiewski.github.com/simple-db-migrate/
Guilherme Chapiewski
taras