Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2006-03-23 : 13:55:50
|
| Hi, thsi is related to SIMFLex'x topic, I am trying to import into sql server tables from Access. The tables from Access are betwwen 700thousand and 3 million records. SOme of them have up to 5 fields as the primary key. The tables are now linked from an Oracle database elsewhere. When I try to import using the import wizard its taking forever. I have to manually copy each linked table in accesss into a local table and then import so that the procedure is more expedited, aditionally, In access also I have to copy first the structury only, open in design view, eliminate all keys, and then copy again but this time append the data. When I get rid of the keys, the importing procedure is much faster. What do you think I should do to make these data transfers faster, more efficient, automatable and maybe dont have the necessity to do the keys trick. Rigth now Im concerned about importing all the large tables from the Oracle database but later I will only require incremental dta transfers,thank you |
|
|
|
|
|
Efficient data transfer?