+32
Completed

Compare Revisions Or Generate Alter Script, to find changes made

Support 5 years ago updated by tushargp 1 year ago 12 1 duplicate

User should be able to compare different revisions and generate "Alter Script" , so that script can be applied to existing database.

Duplicates 1
+1

very useful feature

+1

Would be very helpful to discuss changes with the development team from revision to revsion.

this is possible in simmilar websites offering db designers online. I would stick it in the backlog.

Obviously.  This could be a deal-breaker...the alternative seems to be dropping the existing database tables, running the new script, and reinserting sample data?...or creating a new database, then using a third party tool that generate the diffs?  Ideally, it would work like Google Docs...compare an arbitrary Version X to any Version Y.

Update:  Is in the development pipeline!

Dear Ken,

  We have this ticket in our development pipeline. Once that ticket gets prioritized we will work on it.


Thanks,

Team - SqlDBM

Any update or timeline on this?

Completed

Dear Users,

We have released Compare Feature functionality.

This feature allows SqlDBM users to save time comparing and deploying database schemas. Find and fix errors, and create deployment scripts in minutes to compare changes within different revisions. Now, users can identify changes in tables and DDL scripts. It also detects column discrepancies such as data type, nullability, constraints and defaults.

Check out our release notes here: http://blog.sqldbm.com/compare-database-convert-database-type/ 

Thank you for your patience,

Team - SqlDBM

which type of account one should I have to use this feature?

I am using trial account and do not see the option to generate alter script? Revision feature is there but not alter script

+1

Hello, this is available on our Business and Enterprise plans.

Thanks for reply.