Daniel Smedegaard Buus wrote:

> Brian Wakem wrote:
>
>> 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
>>
>
> Thank you, Martin, for this link! The paper will surely come in handy,
> especially to the DBA.
>
> Cheers,
> Daniel


No problem, but my name's Brian.


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