Re: Convert mySQL db to SQL Server 2k5.

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Dave on May 24 2007 00:53:42:

In Reply to: Convert mySQL db to SQL Server 2k5. posted by Andy Matthews on May 23 2007 23:48:13:

Hi Andy,

First of all, if you want MySql sources listed in SSB you will have to download and install MySql ODBC Driver.
Look in the links page for the link to MySql ODBC Driver or click the link below this message.

Then you will have to set up a DSN in ODBC control panel under system sources.

Then the source will be availabe in SSB.

Select the output as MS SQL in options.
MS SQL have been tested in SQL Server Management Studio.

Hope it helps,
Dave.

> I have a db which I'm converting between the two. I rejoiced when I found this software because my only other alternative was to change all of the column types and various things by hand. I'm using COldfusion and I've got datasources set up in Coldfusion's admin panel for mySQL databases.
>
> I'm having some problems though. When I'm inside SSB:
> 1) No datasources are listed.
> 2) I export from phpmyadmin to a CSV file so try and connect that way but I don't know how to do it. The help files tell me that I can set up a connection to a CSV file, but that's not working, or maybe I'm doing it wrong (who knows).
> 3) Just when I think I've got a connection set up properly, I export the db and it turns out that I'm connected to a readme.txt file in the program's install directory.
>
> Can anyone offer some assistance? I'd be very grateful.

Link to MySql ODBC Driver

Follow Ups:

Re: Convert mySQL db to SQL Server 2k5. - Andy Matthews 20:21:16 May 24 2007 (0)

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> Hi Andy, > > First of all, if you want MySql sources listed in SSB you will have to download and install MySql ODBC Driver. > Look in the links page for the link to MySql ODBC Driver or click the link below this message. > > Then you will have to set up a DSN in ODBC control panel under system sources. > > Then the source will be availabe in SSB. > > Select the output as MS SQL in options. > MS SQL have been tested in SQL Server Management Studio. > > Hope it helps, > Dave. > > > I have a db which I'm converting between the two. I rejoiced when I found this software because my only other alternative was to change all of the column types and various things by hand. I'm using COldfusion and I've got datasources set up in Coldfusion's admin panel for mySQL databases. > > > > I'm having some problems though. When I'm inside SSB: > > 1) No datasources are listed. > > 2) I export from phpmyadmin to a CSV file so try and connect that way but I don't know how to do it. The help files tell me that I can set up a connection to a CSV file, but that's not working, or maybe I'm doing it wrong (who knows). > > 3) Just when I think I've got a connection set up properly, I export the db and it turns out that I'm connected to a readme.txt file in the program's install directory. > > > > Can anyone offer some assistance? I'd be very grateful. > >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]