Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Are you planning to implement data migration?

#53

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

Reported by taras · July 2nd, 2009 @ 02:51 AM

State: resolved
Milestone: v1.3.0
Assigned to: Guilherme Chapiewski Guilherme Chapiewski

Activity

  1. Guilherme Chapiewski
    Guilherme Chapiewski
    • 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

    July 27th, 2009 @ 06:26 PM

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.