• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Archive SQL table to file

I need to archive a table from my sql database to file. Some records within the table contain XML data so i don't think exporting to csv/xls is an option. This data need to be archived programmatically on a regular basis. Also I need to know how to access this data in future if required(Import back in to temp table etc).
Thanks in advance for your help.
1 Solution
Use the bcp tool to export the data to flat files and use the pipe "|" delimiter.

If you want to schedule that for future use, Have the bcp command in a batch file (.bat) and schedule it.
Dear ncollings

when you say archive file, do you mean you want to access this file or just store it.

because if you just need to archive to backup and storage, you can use sql db back up
by right clicking on a database --> task --> backup

but if you want to access it programmatically.
you can detach the database file as is dbname.mdf and connect to it using vb.net

hope it clarifies

ncollingsAuthor Commented:
Pointed me in the right direction
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now