SQL 2005 Table setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan Beck - 31 Dec 2005 05:01 GMT

I'm migrating a MySQL db to a MS SQL 2005 db. I'm using visual studio
2005 for development and remote db admin. Is there any way short of
developing code to import a table which includes all the data.

Thanks in advance
MoonWa

Reply to this Message

Adam Machanic - 31 Dec 2005 06:00 GMT

Do yau have access to SQL Server Integration Services? Or are you forced to
use only VS? If the latter, I think the easiest method will be to dump the
contents of your MySQL database to flat files and then use BULK INSERT to
import them (look up syntax in BOL).

Signature

Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--

> I'm migrating a MySQL db to a MS SQL 2005 db. I'm using visual studio
> 2005 for development and remote db admin. Is there any way short of
> developing code to import a table which includes all the data.
>
> Thanks in advance
> MoonWa

Reply to this Message

Martijn Tonies - 31 Dec 2005 18:02 GMT

You could try our Database Workbench tool - it supports both MySQL
and MS SQL 2005 - see www.upscene.com

Signature

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Reply to this Message