SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DMO UseBulkCopyOption


DMO UseBulkCopyOption

Author
Message
JMartin-392745
JMartin-392745
Old Hand
Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)Old Hand (333 reputation)

Group: General Forum Members
Points: 333 Visits: 357
Guys

We have just migrated a database to SQL Server 2008 from SQL 2000 SP4, there is an in house application that uses DMO to bulk copy data into the load tables.

We are expereincing major performance issues when we switch the database to simple recovery model and a lot of instances in the event logs/SQL logs where the recovery model is being switched to RECMODEL_70BACKCOMP then back to Simple. This is not the case when we switch to Bulk Logged.

We have prety much concluded that the issue is to do with our app, however not being too familiar with DMO (the Dev left many moons ago) I am after some advice.

At the moment the UseBulkCopyOption Property is set to true, what would be the repercussions of setting this to false and would it potentially sole our issue.

Any pointers on how to load lots of data quickly using .NET/SMO etc. would be appreciated.

Also does anyone know if using the BULK INSERT T-SQL would have similar issues to the DMO bulk copy that we are seeing?

Cheers in advance

JQ
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search