Skip to content

Python script to convert SQL tables to CSV from a SQL database. This script will create separate csv for each table with header information

License

Notifications You must be signed in to change notification settings

saianupkumarp/sql2csv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

SQL To CSV (SQL2CSV)

SQL2CSV Downloads all table data from SQL Database into a separate csv for each of the table with header information

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

Prerequisites

  • Python 2.7
  • pymssql (Pip install pymssql)
  • csv
  • Create a folder titled "_Output/SQLOutput" in the root directory to save all the data

Installation

SQL2CSV requires Python 2.7 to run.

Install the dependencies and start the exporting.

$ python sql_all_tables_to_csv.py

License

This project is licensed under the MIT License - see the LICENSE.md file for details

About

Python script to convert SQL tables to CSV from a SQL database. This script will create separate csv for each table with header information

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages