Monday, July 30, 2007

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.

4 Comments:

At Wednesday, April 2, 2008 at 6:46:00 AM PDT, Blogger Alexander Redston said...

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.

 
At Wednesday, April 2, 2008 at 10:50:00 AM PDT, Blogger Nagappan said...

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.

 
At Thursday, June 4, 2009 at 10:20:00 AM PDT, Blogger Nick said...

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

 
At Thursday, June 4, 2009 at 10:49:00 AM PDT, Blogger Nagappan said...

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