Skip to main content
All CollectionsForward & Reverse Engineering
SQL Server - Direct Connect and Reverse Engineer
SQL Server - Direct Connect and Reverse Engineer

Direct connect to SQL Server to obtain and update schema DDL

I
Written by Ivan Lopez
Updated over a week ago

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

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):

  1. Navigate to the Reverse Engineering screen

  2. Click the "Connect to DW" button

  3. Enter the server from the section above

  4. Enter the port (1433 default) details from the section above

  5. Select the user type

  6. Enter the credentials from the section above

  7. 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.


See also:

Did this answer your question?