SQL Server projects can use direct connect to reverse engineer entire schemas in seconds.
Please refer to the instructions below to configure and perform a direct connection to your SQL Server account.
Direct Connect
To establish a direct connection to SQL Server the next details are required:
Server and port
Username
Password
Required permissions:
To perform this action, your user needs to be a member of the db_ddladmin role on the source database.
Using these details, follow the highlighted steps to establish the connection (or get more details in the related articles at the end of this post):
Navigate to the Reverse Engineering screen
Click the "Connect to DW" button
Enter the server from the section above
Enter the port (1433 default) details from the section above
Select the user type
Enter the credentials from the section above
Connect and select the schema to import
IP allowlisting and private networking
Corporate networking and security policies may interfere with connectivity between SqlDBM and SQL Server. If you are unable to connect despite following the guidelines in this article, please make sure that IP blocking or private networking is not interfering.
An easy way to diagnose this type of issue is by attempting to connect to your SQL Server account from a home computer, without using a VPN or any corporate software.
For instructions on allowing SqlDBM through the firewall or private network, please see the related article at the bottom of this page.