如何在按钮单击中将SQL Server备份另存为.CSV格式 [英] how to save SQL Server backup as a .CSV format in button click

问题描述

我想在按钮点击中保存我的sql server备份。

i希望以.CSV格式保存。



怎么做？



任何帮助...



先谢谢你

Hi,i want to save my sql server backup in button click.
i want to save back up as a .CSV format.

how to do this ?

any help ...

Thanks in Advance

推荐答案

您无法将数据库备份为CSV格式。

但是，始终可以将表数据导出到Excel中 - 通过SQL SERVER - 2005 - 出口数据从SQL Server 2005到Microsoft Excel数据表 [ ^ ]。

You cannot backup your database to a CSV format.
However, exporting table data to excel is always possible - go through SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet[^].

您无法更改sql备份文件的格式。你可以找到这里 [ ^ ]可用于标准SQL Server备份过程的所有选项...



如果您想将数据保存为CSV，则需要使用导出导入向导 [< a href =http://msdn.microsoft.com/en-us/library/ms140052.aspxtarget =_ blanktitle =New Window> ^ ]并将数据导出为所需格式（ csv只是众多可用中的一种... ...

Hi,

You can't change format of sql backup file. You can find here[^] all options that are available for standard SQL Server backup procedure...

If you want to keep your data as CSV you need to use Export Import Wizard[^] and export your data into desired format (csv is only one of many that are available)...

这篇关于如何在按钮单击中将SQL Server备份另存为.CSV格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！