how would I set identity insert on at the start of a batch? On Tue, Aug 17, 2010 at 3:23 PM, Wayne Douglas <codingvi...@googlemail.com>wrote:
> Actually appending data to a newly implemented system - but your method is > still v.good and should work. Thanks :) > > > On Tue, Aug 17, 2010 at 1:30 PM, Jason Meckley <jasonmeck...@gmail.com>wrote: > >> if you are using identity, then I don't think you can batch the >> commands, which is where you will get high throughput. you can >> disable/override identity and insert your own id, which would allow >> for batch processing. when finished you can enable identity again. >> >> if this is a one time transfer to populate a new system i would >> 1. disable identity >> 2. insert the data in batches and manage the PK yourself (id = i++) >> 3. enable identity and set the seed to start at Max(Id) +1 from user >> table >> >> On Aug 17, 6:51 am, "wa...@codingvista.com" >> <codingvi...@googlemail.com> wrote: >> > Hi >> > >> > I've just started out writing a new Rhino.Etl project for a data >> > migration we're doing here. The migration needs to be speedy as we >> > need to import > 3,000,000 user records from an old legacy db to a new >> > system and we only have a small timeframe on the night with which to >> > do this. Which is why we chose R.Etl :) >> > >> > My question is - as a basic usage - we're extracting records from >> > table a, b and c. Specific columns from those tables are merged to >> > create a new row which is inserted into table x. I then need to get >> > the ID of that new row and use it to insert another row into another >> > table further down the pipeline. >> > >> > What's the best way of getting that? I don't think doing a select >> > straight after the initial insert is best. Is there a way to use >> > @@IDENTITY inside the OutputCommandOperation? >> > >> > Cheers >> > >> > :) >> > >> > w:// >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Rhino Tools Dev" group. >> To post to this group, send email to rhino-tools-...@googlegroups.com. >> To unsubscribe from this group, send email to >> rhino-tools-dev+unsubscr...@googlegroups.com<rhino-tools-dev%2bunsubscr...@googlegroups.com> >> . >> For more options, visit this group at >> http://groups.google.com/group/rhino-tools-dev?hl=en. >> >> > > > -- > Cheers, > > w:// > -- Cheers, w:// -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to rhino-tools-...@googlegroups.com. To unsubscribe from this group, send email to rhino-tools-dev+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
