List dependencies of database objects
Arno Tolmeijer
shared this idea
We would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server.
-
Anonymous
commented
What's important - during synchronization script generation - to pay attention to drop or change all the dependant objects before. Now simple impossible to use the option of script generation for example if i want to move changes of user data type.
if I choose only user data type DBFORGE studio can't see dependent objects and the result of it - the generated script fails. For example - the Red Gate Compare solves the task without problems. -
ROS
commented
Something like SSMS dependency is enough for the beginning.
In the best case it migh work like displaying dependecies in diagram, such features it available from Devart competitors -
André
commented
What we need on our side is the list of all table by level...
Level 0 is a list of table with no dependency
Level 1 is a list of table with only dependency on level 0
Level 2 is a list of table with only dependency on level 1
Level 3 is a list of table with only dependency on level 2
etc..
This way I can load or transfer data between my DB without droping my FK.
Thanks !
André