how to schedule an export of a table from sql 2019

Question

Robert Wills 20

Feb 23, 2024, 2:13 AM

I would like to schedule a daily export of a table from SQL 2019 giving it a filename of current date. Thank you

LiHongMSFT-4306 31,471 Reputation points

Feb 26, 2024, 3:29 AM

Hi @Robert Wills Do you have further question on this issue, could we offer more support? If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Accepted answer

1 additional answer

LiHongMSFT-4306 31,471 Reputation points

Feb 26, 2024, 3:29 AM

Hi @Robert Wills Do you have further question on this issue, could we offer more support? If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

Greg Low 1,960 Microsoft Regional Director

Feb 23, 2024, 4:21 AM

There are other ways but two basic ways:

Create and schedule SQL Server Agent job that executes the bcp utility from the command line (or PowerShell) (probably the easiest if you just want a dump of the table data)
If you want more control, you could create a SQL CLR stored procedure and just schedule that like any other T-SQL command using a SQL Server Agent job.

Greg Low 1,960 Reputation points Microsoft Regional Director

Mar 11, 2024, 11:00 PM

Mind you, I've never understood why we have a BULK IMPORT but not a BULK EXPORT in SQL Server.

Answer 2

Olaf Helper 46,546

Feb 23, 2024, 5:55 AM