+7
Completed

Allow building table with script in designer

saifkhan 2 years ago updated by Support 2 years ago 5

When in the designer and I want to start off with an existing large table. I should be able to insert a new table then right next to the delete icon click a "Build with script" and paste my existing create statement. After clicking OK it should build the table object which I can use as a starting point.

Answer

Answer
Completed

Dear User,

  We have released  new way of doing Reverse Engineering in SqlDBM, which uses Script to generate the database, and also allows users to do Reverse Engineer on top of existing SqlDBM project, which is very helpful to bering RDBMS and SqlDBM project in Sync. 

This features resolves the issue/idea that you recommended (allows building table using script).

Please check out our blog on new way of Reverse Engineering and other Help articles:

http://blog.sqldbm.com/sqldbm-release-update-oct-31-2018/

http://blog.sqldbm.com/advanced-reverse-engineering/ 

https://support.sqldbm.com/knowledge-bases/2/articles/227-reverse-engineer-or-how-to-generate-a-diagram-from-an-existing-database 


Please feel free to contact us in case you have any further questions.


Thanks

Team - SqlDBM

Under review

I think the feature you looking for is "Template Table", which user can define and whenever user adds new table it creates new table which is copy of the template table, which would give user heads up with his work.

For example: Template table can be like following:



OR


Option of Copy-Paste table, which also gives user quick starting point for new table.


I agree that these features can be very useful to increase productivity. I will certainly discuss this idea with our team.

Let me know if I miss-understood.


The option of "Copy-Paste" is close to what I was referring to. So, lets say I have a new diagram with a blank canvas, and two tables I want to use from my SQL Server (or mySQL). I should be able to copy the gnerated "Script Table as CREATE" script and then have the ability to paste that somewhere in your designer and it would add a table to the diagram. From there I would be on my merry way to extending it with other columns etc. etc.

See sample image.


I like your idea. I will certainly discuss it with our team.

Thank you for great suggestion.

Answer
Completed

Dear User,

  We have released  new way of doing Reverse Engineering in SqlDBM, which uses Script to generate the database, and also allows users to do Reverse Engineer on top of existing SqlDBM project, which is very helpful to bering RDBMS and SqlDBM project in Sync. 

This features resolves the issue/idea that you recommended (allows building table using script).

Please check out our blog on new way of Reverse Engineering and other Help articles:

http://blog.sqldbm.com/sqldbm-release-update-oct-31-2018/

http://blog.sqldbm.com/advanced-reverse-engineering/ 

https://support.sqldbm.com/knowledge-bases/2/articles/227-reverse-engineer-or-how-to-generate-a-diagram-from-an-existing-database 


Please feel free to contact us in case you have any further questions.


Thanks

Team - SqlDBM