Name generation for indexes, primary keys etc

AnatolyUss / nmig

NMIG is a database migration tool, written in Node.js and highly inspired by FromMySqlToPostgreSql.

GNU General Public License v3.0

451 stars 83 forks source link

Name generation for indexes, primary keys etc #100

Open uhickmann opened 2 years ago

uhickmann commented 2 years ago

When a name is not unique enough, it will be shortened to 32 characters and added with a guid. Would it be possible to use the defined names from the mysql db? Maintenance of the same scheme on several server would be much easier.

AnatolyFromPerion commented 2 years ago

@uhickmann The problem is that there're some naming conventions among PG users. For example, index names mostly have the _idx suffix...

Generally it would be possible using some config parameter, something like "use_original_index_names": true (currently not implemented).