SQL Server Upsizing Wizard: Step 2 – Select Data Source

See Also

In this step, you specify options to select the ODBC SQL Server data source or named connection you want to use.

Options

ODBC data sources

Choose this option button to display SQL Server ODBC data sources. When selected, the adjoining list is titled Available data sources.

Connections

Choose this option button to display connections stored in the open database that connect to SQL Server data sources. When selected, the adjoining list is titled Existing connections.

Available data sources

Lists the ODBC data sources that connect to the SQL Server. This list is displayed when the ODBC data sources option button is selected. The Available Data Sources list box lists SQL Server data sources.

Note   The words "SQL Server" must appear in the data source name for Visual FoxPro to identify the data source as a SQL Server data source. If your data source uses a third-party driver to connect to SQL Server, it might not be identified as a SQL Server data source. Use the All check box to display all data sources that are not explicitly identified with the "SQL Server" keywords in the title.

Existing connections

Lists the connections stored in the open database that connect to SQL Server data sources. This list is displayed when the Connections option button is selected. The Existing connections list box lists named connections that connect to SQL Server data sources.

All

Lists all connections or all ODBC data sources available on your system whose titles either explicitly include a known SQL Server-related keyword, are not explicitly identified as a non-SQL Server data sources or connections, and are not Microsoft Desktop Drivers. The list displayed depends upon whether you have the ODBC data sources or the Connections option button selected.

The SQL Server Upsizing Wizard uses the data source or connection you chose to determine which database to display as a possible destination database in Step 5. If the connection does not specify a database, the wizard displays the database that is the default for the data source.

Next

Connects to SQL Server and displays the SQL Server Login dialog box. If you used a named connection with a saved password, the wizard logs you on to the SQL Server you've selected without prompting you for ODBC login information.

Using a Named Connection

If you use a named connection to access your data source, the SQL Server Upsizing Wizard associates the named connection with any remote views it creates during upsizing. If the connection definition includes a password, the "Save Password With View" option in Step 8 of the SQL Server Upsizing Wizard is automatically checked for you and disabled; this prevents the password from being removed from the connection definition.

Using a Data Source

If you use a data source name rather than a connection name to log on to the data source, and you choose to have the wizard create remote views, the SQL Server Upsizing Wizard creates a named connection called "Upsize" (or "Upsize2," "Upsize3," and so on, if a connection definition exists with the suggested name).