migration tool kit

[MDCrab]

hello, i'm trying to get the migration tool kit working. (i'm a programmer.) I don't understand the target source part. I found this link:

http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-targetdb.html

I can connect to a sql server. i'm trying to migrate my sql db to a local mysql db. However, i don't have a username or password. (I do have localhost started. I run IIS without usernames or passwords.)

is there a prior step i have to take that sets up a user and password so the sql migration tool kit can run?

thanks.

 

[MDCrab]

the username and password i mentioned that mysql is looking for seems to come from the "Authentication Methods" page from IIS/Default Web Site/properties. However, I don't know how to work this page.

There's "anonymous access" with a username filled in. The password is greyed out. I don't know what it is.

there's "authenticated access". Click on "basic authentication" and then say "yes" to continue and you get two new options: default domain and realm. I don't know what values go in either.

then there's the "integrated Windows authentication". I clicked it and then clicked ok. Then I tried to use my windows username and password in the mysql toolkit. It didn't authenticate.

any help would be appreciated. thanks.

 

[TonyGroves]

The "target database" is the MySQL database that you want to migrate your data to. You would need to know the hostname or IP address of the MySQL machine, the port number (3306 is the default), username with the appropriate permissions (probably root), the user's password, and the target database name.

I've never used the Migration Toolkit, but those details are needed for any connections to a MySQL server.

 

[MDCrab]

i think i know the problem. it is a network issue. thanks for the reply.