Re: How to import ASCII data

Mike Goodrich writes: >What is the best way to import ASCII data into a multi-table >db which has foreign keys references? Thanx... My personal favorite is using the "LOAD" utility in isql. If you're loading a large percentage of rows in the table, it will be quite a bit faster if you drop any indexes which exist in the table you're loading before you load and recreate them afterwards. As far as foreign key references go, I don't think they should be a problem unless you are using constraints. If you are, I would imagine you could just load your tables containing the primary keys to your foreign keys first. Also, I recommend dropping transaction logging or audit trails before loading (if you use them). This will help your speed too. Hope this helps! Cathy +-------------------------------+----------------------------------------+ | Cathy Kipp | Internet: ckipp@vth1.vth.colostate.edu | | Veterinary Teaching Hospital | | | Colorado State University | Voice: (303) 491-1294 | | Fort Collins, CO 80523 | Fax: (303) 491-1205 | +-------------------------------+----------------------------------------+