How To Export Data From SSMS To CSV in 2023 | # 008

Описание

Source of Sample Data:
https://www.kaggle.com/datasets/perkymaster/school-donations

In this video, we will show you how to export data from SSMS SQL Server to a CSV file. The data gathered was from an open source database ex. Kaggle.

If you're a beginner, this is perfect for you and if you're a seasoned pro, send this to someone looking to get started.

Steps:
1.) Connect to Database → Tasks → Export Data
2.) Choose Data Source → Microsoft OLE DB Driver for SQL Server → Properties → Enter Server Name, Username and Password. Select Database to Export From → OK
3.) Choose Destination → Pick Flat File Destination → Have a blank .csv file ready for export → Debugging Errors
4.) Debugging Errors → Enable Unicode → Next
5.) Check the Exported .csv file

If you are interested in learning more about Azure SQL, please subscribe to our channel for more videos!

Previous Video #007: https://youtu.be/huyIafc2UIM
Next Video #009: https://youtu.be/rUuGYShqZNE

#sqlserver2023 #becomingadatabaseadmin #sql #sqlserver