|
|
Posted by nate.vu on 10/02/60 11:48
Hi there,
I don't think you need to shell out for a seperate tool to do this. You
can use built in SQL Server tools but it might take more time.
One possible option for you is, in SQL Server, create a linked server
to your MySQL database. You'll probably use an ODBC provider but I'm
not sure of the specifics in that regard.
You can create a linked server via the GUI or using T-SQL but it's
generally easier through the GUI. There's a good write-up about it in
SQL Server Books Online so I would refer you to there first. However,
if you're not sure how to add the linked server just give us a buzz and
we'll see if together we can make it work.
For the purposes of transferring data, in your linked server definition
you might want to specify that you will connect to your MySQL database
as a user with admin rights.
After you've defined a linked server you can access the MySQL tables in
a query (once again, techniques for accessing linked servers can be
found in SQL Server Books Online). If your tables are already created
on SQL Server then do:
INSERT INTO <SQL Server Table>
SELECT * FROM <MySQL Table>
If your tables aren't yet created on SQL Server you could do:
SELECT * INTO <SQL Server Table Name>
FROM <MySQL Table>
Hope that helps a bit but sorry if it doesn't
Navigation:
[Reply to this message]
|