如何导入-从Visual Studio 2008中开发的应用程序导出数据库? [英] How to Import - Export Database from an Application developed in Visual Studio 2008?

问题描述

大家好，

我最近在VS 2008中开发了一个应用程序.我希望提供导入-导出给用户的选项，以便用户在崩溃或任何其他麻烦的情况下可以进行备份.还希望使其自动化，这意味着每个月一次在固定的日期和时间开始导出数据库.我该怎么办?请做过此事的任何人帮助我！

谢谢

Hi to all,

I have developed one application in VS 2008 recently. I wish to give an option of import - export to the user so that he can have the back up in situation of crash or any other trouble. Also would like to make it automatic that means start exporting database at fixed date and time once in a month. How could i do this?? Please anyone who has done this before help me!

Thank you

推荐答案

如果您使用的是SQL Server，则可以在软件中包含备份命令，请参见:http://msdn.microsoft.com/en-us/library/ms186865.aspx [ http://msdn.microsoft.com/zh-cn/library/ms186858.aspx [ ^ ].

如果您想自动执行备份，并且正在使用没有代理的SQL Server Express Edition，那么Danillo Corallo会发表一篇精彩的文章，您应该看一下:SQL代理:作业计划程序框架 [

IF you''re using SQL Server, you can include backup command in your software, see: http://msdn.microsoft.com/en-us/library/ms186865.aspx[^]. For restore, see: http://msdn.microsoft.com/en-us/library/ms186858.aspx[^].

If you want to automate backup and you''re using SQL Server Express Edition, which doesn''t have agent, there''s an excellent article by Danillo Corallo, which you should look at: SQL Agent: A Job Scheduler Framework[^]

这篇关于如何导入-从Visual Studio 2008中开发的应用程序导出数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！