From:       To:      

Home > Documentation > PostgreSQL to MS SQL > Tutorial

Step 3 of 6. Connect to SQL Server

This wizard screen allows to provide necessary information for connection to MS SQL server or Azure SQL. In "MS SQL Server" field the name of MS SQL Server instance must be specified. Leave it empty if connecting to the local server. Custom MS SQL port (other than 1433) can also be specified in "MS SQL Server" field as follows:
where 1234 is the custom port. Then select the type of authentication to use when connecting to SQL Server:
  • Windows authentication - SQL Server validates the connection via Windows user information. The user has to be authenticated by Windows before access is granted.
  • SQL Server authentication - SQL Server will use the standard security validation. To use this option, specify user name and password recognized on the target MS SQL Server.

In "SQL Server authentication" mode PostgreSQL-to-MSSQL shows database tables owned by the specified user only. You can change it using "Connect as database owner" checkbox. It will force the program to display all tables from "dbo" tablespace, but only if the specified user has enough privileges to read them. Otherwise, the option will not take effect.

If connection to MS SQL failed, read How to configure SQL Server article for possible workaround.

If you are connecting to Azure SQL, see How to connect to Windows Azure SQL article for related information.

Have questions? Contact us