Converting mySQL database to SQL Server - Help

I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
interested in converting the structure, data, constraints, keys, etc. I
have some experience with SQL server but none with mySQL. I am a C#
programmer not a DBA.
I am looking for some guidance on the best way to accomplish as complete a
conversion as possible with the minimal changes. Any advice, guidance,
samples or links would be greatly appreciated. Thank you.hi:
i am just in the migration process of oracle to ms-sqlserver, not only
the datas(db layer) but also
the client programs(from doa component to ado, delphi).
i have done a lot of work, yes, some programs work fine under sql-server
now(little client codes changed,but
a lot of database procedures need to be translate).
but, for mysql, i am a newbie.
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||Humble
Have a look at this article
http://sql-info.de/mysql/gotchas.html --MySQL examples
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u6rgAP%23PFHA.1268@.TK2MSFTNGP14.phx.gbl...
> Humble
> Have a look at this article
> http://sql-info.de/mysql/gotchas.html --MySQL examples
Are you unaware of sql server service paks? :)|||I'd load the mySQL db into a modeling tool such as ERWIN and the FWD
Engineer the SQL Server Version out of that.
Greg Jackson
PDX, Oregon