|
|
Posted by nicolas.bouchard@gmail.com on 04/25/06 17:09
Hi,
thanks for the reply!
We did considered replication but for a reason unknown to me, we didn't
choose that solution; I can still imagine why, due to the fact we had
to develop an ownership process on certain tables, some tables are
owned by the main and others by the MSDE system and again, depending on
the state of the system.
The system (the main one) will be used by 200+ persons during the day,
the insert rate may be quite a problem with our own generated ids.
Until few days ago, I didn't know of bulk load, I will definitely look
into that for future projects. For this project, the amount of data
transfered between databases are not that big (talking less than 1MB
for the first transfer, then it will be almost nothing).
About my problem, I fixed it and I had few more tests to do; I was
planning to post the fix to my problem here, hoping it will help
someone else. I tried to do too much instructions in one command (my
guess is). Instead of doing everything in the same SQLCommand, I
modified the command to only manage the insert and the select to get
the new values; before calling the update command of the DataAdapter, I
disable the IDENTITY_INSERT then after the comand I enable it.
As I said, thanks for the quick answer !
Nicolas Bouchard
Navigation:
[Reply to this message]
|