SqlBulkCopy implementation available in Mono 1.2.5 preview
Long waiting SqlBulkCopy implementation is now available part of Mono 1.2.5 preview. Needs more testing though... With this almost 99% of SqlClient implementation is, API compatible with MS.NET.
posted by Nagappan @ 2:25 AM
4 comments
4 Comments:
I have been reading the mono source of SqlBulkCopy, I see that the procedure p_tablecollations_90 is hard coded in the file. I created a simple test bulk copy between two databases, both, on SQL2000. I double checked the code ran under .Net 2.0, under Mono I needed to create a new sp_tablecollations_90 procdure.
Once I had it working I found that the performance was slower (35 seconds compared to 0.015 seconds for an insert of 2500 rows) I am continuing to attempt to debug it. Are you by any chance party to any documentation of the stored procedures involved?
Interestingly on another different machine running Mono I had a different result, the insert worked but took about 0.7 seconds which is significantly longer. The two machines (SUSE enterprise server 10.1 and OS X) were both updated within the last few days.
I also noticed that on Sql Profiler there were some differences in the way in which the SQL commands were being processed.
Hi,
That was the first implementation, I reverse engineered the MS SqlBulkCopy implementation and started working on the few tests that I had. Probably its time to rework on them with more examples. You can file your test case in a bug report in bugzilla.novell.com, it will be easy for testing and it can also be tracked.
If you don't mind me asking, how did you implement a port of sp_tablecollations_90 to work in MSSQL2000? SqlBulkCopy has always worked for under the normal dotnet framework and MSSQL2000 but apparently Mono's implementation doesn't support MSSQL2000? Any help would be GREATLY appreciated.
thanks. -nick
Can you please file a bug on this ? The current Mono version is 2.4, probably you can try with it ?
Post a Comment
<< Home