Daniel Smedegaard Buus wrote:

> Hey there
>
> I'm in a project to build an eCommerce site using TYPO3. We've been trying
> to get everything up and running on a Windows + IIS + MS SQL setup (for
> political reasons), which has proven to be very problematic. Actually,
> we're at the point were we pretty much have to switch to MySQL for things
> to work out.
>
> Thing is, we already have a 43-table 15+ GB MS SQL database with commerce
> items that we need to migrate to the MySQL server. There are no stored
> procedures, but there are a handful of Views (I don't think we really need
> them), and relations exist in some form within the database (I know
> nothing of the workings of MS SQL myself, and unfortunately, my boss and
> creator of the database is currently in Malaysia, so you'll have to bear
> with me in being a bit unspecific, sorry).
>
> Do you have any recommendations on how to (relatively) easily replicate
> the MS SQL database to a new MySQL database? I have installed MySQL 5 on
> the same server that holds the MS SQL server. Next up is to "convert" it.
> Needless to say, it'd be nice to do this "the right way", whichever way
> that really is
>
> Thanks in advance for any help,
> Daniel Buus


Have a look at
http://www.mysql.com/why-mysql/white...ssql2mysql.php

--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png