From: Bruno B. B. Magalhaes (brunomagalhaesblackbean.com.br)
Date: Tue Mar 24 2009 - 10:49:57 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi guys,

the easiest is to use MySQL Migration Toolkit, I've sucessfuly used it
with SQL Server (2000 and 2008) and Oracle 9i, all with simple
structures and simple data, but worked VERY well...

Regards,
Bruno B. B. Magalhães
Sócio-Diretor de Negócios e Tecnologia

BLACKBEAN CONSULTORIA
Rua Real Grandeza 193, Sala 210, Botafogo
Rio de Janeiro, RJ, 22281-035, Brasil

+55 (21) 9278-0082
+55 (21) 2266-0597
www.blackbean.com.br

Esta mensagem pode conter informação confidencial e/ou privilegiada.
Se você não for o destinatário ou a pessoa autorizada a receber esta
mensagem, não pode usar, copiar ou divulgar as informações nela
contidas ou tomar qualquer ação baseada nessas informações. Se você
recebeu esta mensagem por engano, por favor avise imediatamente o
remetente, respondendo o e-mail e em seguida apague-o. Agradecemos sua
cooperação.

This message may contain confidential and/or privileged information.
If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based
on this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.

On Mar 24, 2009, at 11:21 AM, mos wrote:

> At 06:28 AM 3/24/2009, you wrote:
>
>> Hello all.
>>
>> I`ve got the question how mysql will have to be set up, that it can
>> handle round about 7.000.000 records most efficiently.
>>
>> What do you think about the the hard and software requirements in
>> order to match the best combination?
>>
>> The data will come from oracle, so it would be interessting to, how
>> I will have to import the data. Does this work once, or will I have
>> to divide the data in several parts for import?
>>
>>
>> Best Greetings,
>>
>> Frank
>>
>>
>>
>
> Frank,
> The fastest way to import data from Oracle would be as a CSV file
> and then use Load Data Infile to import the data into MySQL. 7
> million records should load in a couple of minutes. Make sure you
> confirm the row counts are equal after you have imported the data.
>
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=brunomagalhaesblackbean.com.br
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]