Would it be possible to convert the datatypes, e.g. oracle VARCHAR2() to SQL Server VARCHAR() and Oracle NUMBER() to SQL Server NUMERIC()? Any enhancement would be very useful. If possible please prioritize Oracle to SQL Server and SQL Server to Oracle. Thank you!
Dark themes are better for the eyes. And working long hours on a diagram, that would be an ultra nice to have!
I figured out how to accomplish that. First edit the foreign key and remove the relationship. Then remove the connecting line. That way the previous referenced foreign key column will not be deleted from the table. So we implicitly have the option to delete the foreign key column or not. Happy!
Can we make the deletion of the column from the foreign key table optional? Sometimes we need to replace a table that carries the primary key and in that case the the foreign key field(s) which can affect many tables becomes a very difficult exercise to bring those FK fields back to the affected tables.
Customer support service by UserEcho