I could either leave my project spic and span and let the copy take almost an hour, or find an elegant way to implement COM and shrink the copy process down to a couple of minutes. In my case, there wasn't much of a choice. The bottom line is that it is up to you on whether you want to include COM support in your project, and you'll have to weigh the pros and cons and then decide. It will make your setup and installation more complex, but will add functionality that may otherwise not be available from within the. This article, then, discusses the implementation of an SQL server to Microsoft Access copy process that is performed by Microsoft Access, runs within a C# project, and minimizes the impact COM has on the overall application by using late binding. NET project automatically means including COM, and a lot of people cringe at the thought. The biggest problem with this was that including support for Microsoft Access in a. The ultimate solution, then, was to find a way to have Microsoft Access perform the copy all the while running within a C# project. The BCP process alone was able to match the time record achieved by the Microsoft Access import, but useless since it could not export to Microsoft Access. Using BCP (although this can only export to a text file or SQL Server binary file).I do not have the exact times it took for each of the tests, but they were all much longer than doing a simple import through Microsoft Access. When I compared the time it took to perform this import, it consistently beat the other tests by a wide margin of at least twenty to one. My frame of reference was Microsoft Access itself, which has the ability to import tables from an ODBC source. No matter which approach I followed, however, the speeds at which the copy was being executed were far too low and simply unacceptable. The problem was simple: I needed to copy a fairly large amount of data from a table in a SQL Server database to a table in a Microsoft Access database. In a recent project I worked on, I came across a pretty serious problem that seemingly had no solution.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |