So, after you have managed to access your data on Delighted and you have also figured out the structure that data will have on your database, you need to load any data into the database, in our case, into a Microsoft SQL Server.
As a feature-rich and mature product, MS SQL Server offers a large and diverse set of methods for loading data to a database. One way of importing data into your database is by using the SQL Server Import and Export Wizard. With it and through a visual interface, you will be able to bulk load data from a number of supported data sources.
Another way for importing bulk data into an SQL Server, both on Azure and on-premises, is by using the bcp utility. This command-line tool is built specifically for bulk loading and unloading of data from an MS SQL database.
Finally and for compatibility reasons, especially if you manage databases from different vendors, you can BULK INSERT SQL statements.
Similarly, and as it happens with the rest of the databases, you can also use the standard INSERT statements, where you will be adding data row-by-row directly to a table. It is the most basic and straightforward way of adding data in a table but it doesn’t scale very well with larger datasets.