Convert mySQL db to SQL Server 2k5.

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

Posted by Andy Matthews 69.245.14.143 on May 23 2007 23:48:13:

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.

Follow Ups:

Re: Convert mySQL db to SQL Server 2k5. - Dave 00:53:42 May 24 2007 (1)
- 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:
> 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 ]