Next, you'll see the Microsoft SQL Server Source screen. Enter your MSSQL database connection information:
- Server host name or IP address
- Instance name if connecting to SQL Express, or a particular instance name if running multiple instances of SQL Server on the same machine
- Authentication method — Windows or Server Authentication
- Username and password if using Server Authentication
In this example, we'll connect to MS SQL Server running on the local machine using Windows Authentication.
Data Loader also lets you choose the connection method — OLE DB Provider or ODBC Driver, both already installed when you install Microsoft SQL Server. For this demo, we'll use the default MS SQL OLE DB Provider.
Enter your server host name, choose the proper authentication method, and click Connect. If everything is correct, you'll get a "Connected Successfully" message:
If you're having trouble connecting to MS SQL Server, see common connection problems and how to resolve them.
Now click the Select Database dropdown to get the list of available databases — we'll choose "Northwind". As soon as you select the database, Data Loader populates the list of tables and views, from which you can choose whatever you want to convert to MySQL. In this demo, we'll select all tables:
Click Next to continue.