By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,910 Members | 1,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,910 IT Pros & Developers. It's quick & easy.

MySQL -> ms-sqlserver

P: n/a
Hi,
I have to convert an MySQL database into a ms-sqlserver database.
Anyone know a software (is is possible freeware or not so expensive) to
translate database?
I have only to translate tables, no triggers or stored procedures.
Or anyone can send me a link to a web site about this problem?
Tank you and escuse for my terrible english!

Simone (form Italy)
May 22 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

May 23 '06 #2

P: n/a
Ciao Simone,
se fai un Dump, io ho un programma per ricaricarlo in SQL server.
Fammi sapere...

-tom
Simone ha scritto:
Hi,
I have to convert an MySQL database into a ms-sqlserver database.
Anyone know a software (is is possible freeware or not so expensive) to
translate database?
I have only to translate tables, no triggers or stored procedures.
Or anyone can send me a link to a web site about this problem?
Tank you and escuse for my terrible english!

Simone (form Italy)


May 24 '06 #3

P: n/a
Hi!

You could also use Oracle Migration Workbench (Migration Workbench).
Workbench can be downloaded from the technet website for free.
http://technet.oracle.com/tech/migra...h/content.html.
o Migrate multiple MS SQL Server 6.5, MS SQL Server 7.0, MS SQL Server
2000,
MySQL3.22 and 3.23 Sybase Adaptive Server 11 and 12 databases to a single
Oracle database.

Cheers ;)
Jack
"Simone" <sp****@katamail.com> wrote in message
news:e4***********@newsreader1.mclink.it...
Hi,
I have to convert an MySQL database into a ms-sqlserver database.
Anyone know a software (is is possible freeware or not so expensive) to
translate database?
I have only to translate tables, no triggers or stored procedures.
Or anyone can send me a link to a web site about this problem?
Tank you and escuse for my terrible english!

Simone (form Italy)

May 26 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.