How to convert MySQL to SQL 2k5?

Question

Post reply

How to convert MySQL to SQL 2k5?

halifaxdal

SSCoach

Points: 19741
More actions
May 20, 2010 at 3:16 pm

#139090

Hi folks,
I have no MySQL skill set, I wonder if there is any quick way I can convert a MySQL dump to SQL 2k5? I need to convert it completely, so evaluation copy of third party software might not be enough.
The size is roughly 100 MB, with probably 70 tables.
I don't know and I don't want to set up MySQL or Apache or PHP environment, if possible.
Thanks lots.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

What links/hints/information did you get using a simple Google search?

It seems like there is a load of information out there...

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 2

A quick serch in MSDN brought this back:

Guide to Migrating from MySQL to SQL Server 2005

Joie Andrew
"Since 1982"

LutzM SSC Guru Points: 107049 More actions · Answer 3

Joie Andrew (5/20/2010)
A quick serch in MSDN brought this back:
Guide to Migrating from MySQL to SQL Server 2005

I've seen that too but didn't feel like a human search engine today... 😉

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

halifaxdal SSCoach Points: 19741 More actions · Answer 4

lmu92 (5/20/2010)
What links/hints/information did you get using a simple Google search?
It seems like there is a load of information out there...

Whoa.... it doesn't sound friendly or patient to me, there are bunch of reasons why people like to post question in a forum, if you are not in good mood or just for whatever reason you don't want to answer, you can just be a good listener.

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 5

halifaxdal,

I don't think that Lutz was trying to give you any attitude at all. I think he was simply trying to identify what you have already done in order to help you better.

Also, a lot of the help that is provided in forums like this is not simply providing answers, but showing others ways to help themselves. It makes us better DBAs/Developers and overall IT professionals in the long run.

Joie Andrew
"Since 1982"

LutzM SSC Guru Points: 107049 More actions · Answer 6

Joie Andrew (5/20/2010)
halifaxdal,
I don't think that Lutz was trying to give you any attitude at all. I think he was simply trying to identify what you have already done in order to help you better.
Also, a lot of the help that is provided in forums like this is not simply providing answers, but showing others ways to help themselves. It makes us better DBAs/Developers and overall IT professionals in the long run.

Couldn't have explained it any better. Thanx, Joie!

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]