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=brunomagalh...@blackbean.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org