0
Answered

How can I extract sql script only for changes that we made on our model

Kesiya Abraham 4 years ago updated by Michał Kołodziejski 4 years ago 6

If I add a new column,how can I generate SQL script for that particular change

Answer

+1
Answer

Hello,


There is no way to that easily right now. You can generate 'drop' script and 'creation' script, but it works only for fresh databases and requires deletion of data in the table.


We've implemented a migration tool which can do that, but we are still testing it. We are going to release it in about 2 weeks.


I hope this helps.




+1
Answer

Hello,


There is no way to that easily right now. You can generate 'drop' script and 'creation' script, but it works only for fresh databases and requires deletion of data in the table.


We've implemented a migration tool which can do that, but we are still testing it. We are going to release it in about 2 weeks.


I hope this helps.




I'd also be very interested in this. Are you still expecting to release this soon?


Thanks in advance.

Answered

This feature has been introduced with yesterday release! You can now generate migration script between model versions. You can find this option on "Model detals" page in the menu on the right-hand side. Right now, the current version is selected as target version and you only need to choose "source version" - a starting point. We'll shortly introduce option to select destination version from "Model versions" section on "Model details" page.

Ah, one more note. This is available for PostgreSQL and MySQL DBMS-es only at the moment.

When will the migration script for MS SQL database be released? That is the one feature we are waiting for before moving from Erwin to Vertabelo at our company.

Migration scripts for SQL Server will probably be on production with a next release. However, I can't tell you when it happens. It might take one or two months. Sorry for not being precise, but that's all I know at the moment.