Microsoft SQL Server

Microsoft SQL Server

The Microsoft SQL Server Source reads data from a Microsoft SQL Server.

Connection

Specifies the connection string to be used to connect to the database.

For details about SQL Server connection strings see http://www.connectionstrings.com/sql-server-2008.

Choose a previously used connection

Click on the connection Drop Down to choose a connection previously used.

Create a new Connection

Click on the "New Connection" Button to create a new connection.

Load Views

By default DbTransfer only loads Tables.

By enabling Load Views, SQL views will also be loaded from the database.