The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Bulk Inserts into SLX
Posted: 23 Sep 08 6:09 AM
|
Is there an easy way to do BULK Inserts into a Custom Table I've created in the SalesLogix DB?
I have to do all the inserts through the Provider so that SLX can do all of it's synchronizing and "other stuff"
But I have like 20,000 lines of data I need to insert into a table and I was curious if there was a way I could just use
Insert BULK
And than somehow indicate to the SLX system that it needs to "synchronize" with that data?
Or do I just need to do line by line inserts? |
|
|
|
Re: Bulk Inserts into SLX
Posted: 03 Oct 08 6:17 AM
|
anything?
It seems like the only way to insert data into SLX is line by line by line by line by line
I need to take 89,000 rows from one table and insert them into another table
the ONLY way I've found to do this is to retrieve all 89,000 into a local datasource than one by one insert each line into the second table...
which (on our production server) seems to be taking forever and occasionally locking...
What would be really nice to do is:
insert into TABLE1 (COLUMNS)
select (VALUES) FROM TABLE2
But sadly even when you set AUTOINCREMENT TO True on the sectabledefs table this statement fails
the autoincrementing only supports line by tedious line 
any suggestions or insight would be wonderful
thanks
|
|
|
|
Re: Bulk Inserts into SLX
Posted: 03 Oct 08 12:56 PM
|
Hi Shane,
Are you using DTS to copy the info in? My experience with DTS is that it works very well when the AUTO flag is on for key generation. It is very good at doing it very fast too.
Stephen
|
|
|
|
Re: Bulk Inserts into SLX
Posted: 03 Oct 08 3:35 PM
|
I'll try that....
Does insert into TABLE (COLUMNS) select (vALUES) FROM TABLE2
work with SLX very well?
I tried running it through the provider and the createdate, etc... fields all remained null
(which is really no surprise)
but would a statement like that generally be a bad idea?
or will it still synchronize with remote clients etc...? |
|
|
|
Re: Bulk Inserts into SLX
Posted: 03 Oct 08 6:53 PM
|
You cannot do bulk inserts via the provider. As you have suggested you will need to loop through your data and insert one at a time.
Timmus |
|
|
|
Re: Bulk Inserts into SLX
Posted: 06 Oct 08 8:14 PM
|
I agree with Stephen: DTS/SSIS is the way to go. Performance should not be so bad, but the amount of dev work required when compared with INSERT INTO is considerable ...
Phil |
|
|
| |
|