search

wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
67 stars 3 forks source link

Modified Model - compare with DB does not generate scripts or update the database #46

Closed zork2112 closed 3 years ago

zork2112 commented 3 years ago

Trying to sync database to model. Connected Database = SQL server Steps:

  1. Refresh Model Schema from DB

  2. Review Differences

  3. Click all to database

  4. Modify Database - Commit Database Actions = brings up a blank execution box with says Sql (0 of 0) Generate SQL Scripts option - says it generates a script, but nothing shows up. Also tried selecting specific item and it does nothing either.

zork2112 commented 3 years ago

It actually did make the change, but continued to show a difference between the model & database. I just had it apply changes to the model and that stopped the diff dialog from finding differences.

wise-coders commented 3 years ago

Eventually please add few screenshots and the CREATE TABLE from SqlServer for the involved table. Probably something is not reversed engineer correctly.

Best regards, Dragos Pruteanu

PS. Any feedback about DbSchema or database-specific issues is welcome.