[GH-ISSUE #25] Prevent drop table #152

New issue

Open

opened 2026-03-07 20:41:36 +03:00 by kerem · 4 comments

kerem commented

2026-03-07 20:41:36 +03:00

Owner

Originally created by @CodingPeak on GitHub (Aug 24, 2016).
Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/25

Is there a way to prevent drop table and drop column in the output?

Originally created by @CodingPeak on GitHub (Aug 24, 2016). Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/25 Is there a way to prevent drop table and drop `column` in the output?

kerem commented

2026-03-07 20:41:38 +03:00

Author

Owner

@jasdeepkhalsa commented on GitHub (Aug 24, 2016):

You can just use the tablesToIgnore: and/or fieldsToIgnore: options in your .dbdiff file: https://github.com/DBDiff/DBDiff#dbdiff to ignore tables and fields which don't exist in the other database. Otherwise you cannot prevent table and column drops as this is a diff-ing algorithm meant to make both databases the same.

@jasdeepkhalsa commented on GitHub (Aug 24, 2016): You can just use the `tablesToIgnore:` and/or `fieldsToIgnore:` options in your `.dbdiff` file: https://github.com/DBDiff/DBDiff#dbdiff to ignore tables and fields which don't exist in the other database. Otherwise you cannot prevent table and column drops as this is a diff-ing algorithm meant to make both databases the same.

kerem commented

2026-03-07 20:41:38 +03:00

Author

Owner

@CodingPeak commented on GitHub (Aug 24, 2016):

I understand. But I'd really need to be able to add tables and columns without losing existing tables and columns and their data. A column name change for example, deletes and creates this column, deleting all column data with it.

@CodingPeak commented on GitHub (Aug 24, 2016): I understand. But I'd really need to be able to add tables and columns without losing existing tables and columns and their data. A column name change for example, deletes and creates this column, deleting all column data with it.

kerem commented

2026-03-07 20:41:38 +03:00

Author

Owner

@jasdeepkhalsa commented on GitHub (Aug 24, 2016):

If there was a way we could detect two columns are the same, then we may be able to do a less harsh operation like delete and re-create - unfortunately I don't think such a way exists.

You may wish to manually write the migration just for the column name update and then let DBDiff do its magic with the rest of the data diff

@jasdeepkhalsa commented on GitHub (Aug 24, 2016): If there was a way we could detect two columns are the same, then we may be able to do a less harsh operation like delete and re-create - unfortunately I don't think such a way exists. You may wish to manually write the migration just for the column name update and then let DBDiff do its magic with the rest of the data diff

kerem commented

2026-03-07 20:41:38 +03:00

Author

Owner

@jasdeepkhalsa commented on GitHub (Aug 25, 2016):

In the future we could introduce here, the ability to skip particular tests on particular tables perhaps?

@jasdeepkhalsa commented on GitHub (Aug 25, 2016): In the future we could introduce here, the ability to skip particular tests on particular tables perhaps?