acrosman / Salesforce2Sql

Electron app to convert a Salesforce org's schema into a similarly shaped database.
MIT License
15 stars 8 forks source link

Generated SQL Files don't include indexes #203

Open acrosman opened 1 year ago

acrosman commented 1 year ago

Describe the bug When saving SQL files, the create index statements are missing.

To Reproduce Steps to reproduce the behavior:

  1. Select an object to save to schema SQL file.
  2. Proceed through steps to create tables, but intentionally fail to connect to the database (MySQL at least, probably also others)
  3. Save to SQL.
  4. SQL file will have create table statement, but no indexes.

Expected behavior SQL File should have all statements that would have been attempted to generate the table.

Additional context There may be other differences between the generated statements and what gets run when connected. It's possible this is an issue in the underlying calls from Knex.