What is stored procedure vs sql loader

Jonathan Brotto 200 Reputation points
2024-06-14T18:48:46.0466667+00:00

I'm reviewing some system setup on SQL server and for inbound data we use a stored procedure and outbound we are using the something called SQL Loader. Like a definition of both and tools that could be used.

I'm the business analyst and lot of documentation is technical.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,343 questions
0 comments No comments
{count} votes

Accepted answer
  1. LiHongMSFT-4306 25,651 Reputation points
    2024-06-17T02:49:16.4366667+00:00

    Hi @Jonathan Brotto

    Stored procedures are a set of SQL statements that have been pre-compiled and stored in the database. They are usually used to perform complex operations such as data validation, data manipulation, and business logic execution.

    Regarding SQL Loader, I am not an expert on that. It is an Oracle utility that allows you to efficiently load large amounts of data from external sources into a database.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Michael Taylor 51,346 Reputation points
    2024-06-14T19:26:54.7633333+00:00

    SQL Loader is an Oracle tool. It is not part of the MS SQL Server toolset. Just a complete guess but you're importing data into SQL using stored procedures but you're exporting data back to Oracle using Oracle's SQL Loader tool. This is most likely to take advantage of their toolset to get the data into Oracle.

    1 person found this answer helpful.
    0 comments No comments