- DATABASE WORKBENCH SQL SERVER HOW TO
- DATABASE WORKBENCH SQL SERVER DRIVERS
- DATABASE WORKBENCH SQL SERVER DRIVER
If you have a SQL Server instance in the same machine where you installed MySQL Workbench then you should also have the second driver listed in the image (named “SQL Server Native Client…”). This driver is frozen at the level of functionality provided by SQL Server 2000 and it should be enough for you if your database doesn’t make use of the new features and datatypes introduced after this SQL Server version. The first one listed here (named “SQL Server”) comes preinstalled with Windows (you should have it as well).
DATABASE WORKBENCH SQL SERVER DRIVERS
You should see something like this:Īs you can see, I already have two SQL Server ODBC drivers installed.
Start the Windows ODBC Data Source Administrator from MySQL Workbench using the Plugins –> Start ODBC Administrator menu item or just open a Windows terminal and type odbcad32.exe. You should check if you have an ODBC driver for SQL Server. For Windows 2000 and earlier these can be installed with the Microsoft Data Access Components (MDAC). Any recent version of Windows comes with some ODBC drivers installed. You can read there that you need an ODBC driver for your source RDBMS installed. Read carefully the Prerequisites section. Let’s start now... Open MySQL Workbench and start the Migration Wizardįrom the main MySQL Workbench screen you can start the Migration Wizard by clicking on the Database Migration launcher in the Workbench Central panel or through Database –> Migrate in the main menu.Ī new tab showing the Overview page of the Migration Wizard should appear.
DATABASE WORKBENCH SQL SERVER HOW TO
Other blog posts will follow on how to proceed in those cases. The Migration Wizard is also available in the Linux and Mac versions of MySQL Workbench, but running it from Windows will save us from installing an ODBC driver to connect to our SQL Server instance.
For this tutorial I’m using MySQL Server 5.5.15 CE installed in the same PC where MySQL Workbench is running. The Migration Wizard supports MySQL versions from 5.0 onwards so make sure you have a supported version. A running MySQL Server instance with proper user access.Keep in mind that the Migration Wizard officially supports SQL Server 2000 and newer so older SQL Server versions might not work. I’m using the standard “sa” user, which has full privileges. You can use whatever SQL Server version you have at hand.
I have a remote SQL Server 2000 instance available and the sample Northwind database on top of it. (I’ll call this database from now on the source database). A running SQL Server instance in which you have proper access to the database you want to migrate.In the rest of this post I assume that you have: So let’s get our hands dirty and run through the Migration Wizard in order to migrate a Microsoft SQL Server database to MySQL. Additionally, you can use it to perform MySQL to MySQL database copies, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL. In this initial version, migrations from Microsoft SQL Server are supported, but it should also be possible to migrate from most ODBC capable RDBMS as well, using its generic RDBMS support. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. MySQL Workbench 5.2.41 introduces a new Migration Wizard module.