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

Описание: Source of Sample Data:
https://www.kaggle.com/datasets/perkymaste...

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:    • How to Export Data From SSMS To Excel in 2...  
Next Video #009:    • Creating a Local Database in SSMS in 2023 ...  

#sqlserver2023 #becomingadatabaseadmin #sql #sqlserver