SQL Homework – August 2019 – Getting the data out

,

Everything else aside two of the most important tasks of a database are to get data in, and get data back out again. This month let’s practice getting that data back out. Try out at least 3 of the following by exporting one of your test tables into a CSV file (or some other format if you prefer).

  • BCP – A command line tool used to import and export data. Great for automation.
  • Import/Export wizard – Creates an SSIS package that can import or export data. This can be used as a one time import/export or the package can be saved for later use/editing.
  • SSIS – Create your own SSIS package manually. This is more work than using the wizard but you have an amazing amount of control. This is also great for automation.
  • Save or copy and paste the data from the output in SSMS. – This is a nice quick and dirty way to grab data.
  • Powershell – PoSH can do anything. Really. I’ve used it to wash my dishes on a couple of occasions. Create a script to get the data from a table and export it. Another great tool for automation.
  • The coding language of your choice. – Same as Powershell really. If you have some development background, pick a language and write yourself a script to export a table.
  • Other methods – Any other methods you can think of.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate