There is a newer version of the record available.

Published November 9, 2022 | Version v1

The Mass Insertion of SQL Server Records Algorithm

Authors/Creators

  • 1. University Of South Africa

Description

This paper presents a new algorithm for the mass insertion of records into a SQL Server database and it can handle any file extension which pandas supports. There is a problem with the current method of inserting records into a SQL Server database. We are only limited to .csv, .txt files in the SQL Server Management Studio Import Flat File Wizard. The algorithm is written in Python and it can handle any file extension which pandas supports. It is proven that the SQL Server Management Studio Import Flat File Wizard is 2.18 times faster than the algorithm but that is only for one file. When having n number of files and automation is required then my algorithm is the way to go. I own the sqlserver module on PyPI. It simplifies P yODBC module and it is a wrapper around the P yODBC module. In this paper I will show how to use the sqlserver module to insert records into a SQL Server database and also explain the algorithm to commit the records into the database.

Files

TheMassInsertionOfSQLServerRecordsAlgorithm.pdf

Files (243.7 kB)

Name Size
md5:d4ca8cbada8c6c7e4b4cf0e288b81187
243.7 kB Preview Download