Loading data into tables [message #481010] |
Fri, 29 October 2010 02:51 |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
|
|
Guys,
We completed creating a replicate of dB_01 to dB_02 (housed in a single DEV server). But dB_02 had only table structures (no records). What would be our fastest option (tools, commands, etc.) to load more than a thousand new records for each of the 20 tables of dB_02?
Thanks for your help.
|
|
|
Re: Loading data into tables [message #481012 is a reply to message #481010] |
Fri, 29 October 2010 02:57 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote:What would be our fastest option (tools, commands, etc.) to load more than a thousand new records
Not clear, load from existing rows or load completly new rows?
Is there any dependency (FK) between the tables?
Regards
Michel
[Updated on: Fri, 29 October 2010 02:58] Report message to a moderator
|
|
|
|
|
|
|
|
|