SQL 2005 Table setup

31 Dec 2005 5:01 AM

Jonathan Beck

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

31 Dec 2005 6:00 AM

Adam Machanic

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).

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

"Jonathan Beck" <Jonathan.B***@cox.net> wrote in message

news:Pfotf.21413$Ou3.19783@dukeread09...
Show quote

> 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

31 Dec 2005 6:02 PM

Martijn Tonies

> 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.

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

--
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