kitchen_sync

kitchen_sync copied to clipboard

MySQL -> Postgres | ENUM Columns

4

Is it possible to add some kind of laravel compatibility flag to parse ENUM columns in MySQL as varchar for Postgres to avoid having to CREATE TYPE for each enum...

georgimorozov

YAML FORMAT

2

hi Willl Bryant I'm using kitchen sync and I'm having a problem using the YAML format. can you help in any example in yaml format needed in kitchen sync. Because...

fendys01

MySQL CI -> PostgreSQL collation-dependent varchar primary keys result in 'Duplicate key value violates unique constraint'

11

Syncing MySQL to PostgreSQL with Kitchen Sync 2.10. The first sync is successful, on the consequent sync right after the first one (i.e. syncing the same data from the source)...

easeev

Incomplete PostgreSQL schema when syncing from a user with privs on specific tables only

15

I have PG->PG synchronization process. Some of my tables use varchar as a primary key. When I run synchronization process through the kitchen-sync I have no error but: * the...

RostislavKonstantinov

MySQL UTF8 encoding issues with table-specific encodings/collations

5

So syncing to tables between 2 MySQL databases I found the next error `Error in the 'to' worker: Incorrect string value: '\xF0\x9F\x91\x8D' for column 'msg' at row 2647` The column...

javier-sanz

Keep column comment

1

## Problem: When I syncing mysql to mysql, It will lost from mysql column comment. ## Except: Support keep column comment

eeokee

Hash doesn't match if string expression used for numeric column

1

Sort of a technicality, but if there's a numeric column and a filter file used with a `replace` option, this will work normally: ``` numtest: replace: val: "10" ``` But...

willbryant

Foreign keys are not being imported

2

fabioespinosa

Option to sync insert only

7

Awesome project, works amazingly well. We are using it in my company to transition to postgres, and during the syncing phase it would be pretty useful to have a "just...

fabioespinosa

Postgres unique index with expressions is incorrectly transferred

1

Hello, My source Postgres 11 db has the following index: `create unique index ix_permission_unique on permissions(tenant_id, name, coalesce(scope_type, ''), coalesce(scope_id, ''));` COALESCE expressions are used to allow NULL only once...

nefremov