Sql-server – HeidiSQL solution for SQL Server error 18488

SQL Profiler does not come with SQL Server Express 2008 R2*. You can get it with the installation media for Datacenter, Enterprise, Standard, Web, Developer, or Workgroup licenses.

If you have the installation media, you can get Profiler that way. Otherwise, Developer Edition is available for $50.

There are some other tools available, and you could even create your own server-side traces (for example) without Profiler. Then, use a tool like Qure Workload Analyzer to review the trace files. With 2008 R2, you could in addition use Extended Events to track activity. The advantage is that both of these are less of a performance hit than running Profiler would be.

If you're looking at a point-in-time solution and can install procedures, Adam Machanic's sp_whoisactive could be something to look into.

* Profiler is available in SQL Server 2012 Express Edition SP1 onward. You need to select SSMS (Complete) in the installation options.

MySQL is my area of expertise and SQL Server isn't... but it looks like the answer is you definitely can manage the migration with SSMA on a client PC, but it also appears that both your client machine and the SQL Server need connectivity to the MySQL server. Reading between the lines, it sounds as if the client machine might use its connection to MySQL to discover the schemata and then something from the server-side components installed on the SQL Server would subsequently connect directly to MySQL to fetch the actual data rather than the data being actually piped through the client machine where you're using SSMA.

To use SSMA, you first must install the SSMA client program on a computer that can access both the source MySQL database and the target instance of SQL Server or SQL Azure. Then, install the MySQL providers (MySQL ODBC 5.1 Driver (trusted)) on the computer that is running SSMA Client Program.

^{— http://technet.microsoft.com/en-us/library/hh313129.aspx}

In addition to installing SSMA, you must also install components on the computer that is running SQL Server. These components include the SSMA extension pack, which supports data migration, and MySQL providers to enable server-to-server connectivity.

^{— http://technet.microsoft.com/en-us/library/hh313121.aspx}