simple-bcp 0.4.0

A Simple yet powerful bcp wrapper

Simple BCP

A Simple yet powerful Python bcp wrapper.
bcp (bulk copy program) is a command line tool that copies data from / into MSSQL.
You can read more about bcp here

Installation

You can install the package using pip:

pip install simple_bcp

Usage

import simple_bcp

bcp = simple_bcp.BCP()
database_parameters = simple_bcp.MsSqlDatabaseParameters(
    server_hostname="your-sql-server-hostname",
    username="user",
    password="pass"
)
output_file_path = bcp.download_table(table_name="your_table_name", database_parameters=database_parameters)
print("table data is available at ", output_file_path)

Requirements

• Python >= 3.10
• bcp installed on your machine. How to install bcp

Author

Noam Fisher