如何从数据库生成脚本 [英] how to generate script from database

问题描述

我有microsoft sql server management studio 2008，我有一个问题，我们如何生成数据库名称login的脚本（可以保存为.txt格式文件）。



出于某些目的，我的系统崩溃，因此通过生成脚本，它将帮助我再次从该危险中重新生成我的数据库。



Plz只给出了点击和下一步的步骤。提前谢谢

I have microsoft sql server management studio 2008, and I have a question regarding it, that how can we generate script (which can be saved in .txt format file) of the database name "login".

It is for purpose that some times my system crashes and hence by generating script it will help me to regenerate my database again from that hazard.

Plz give only steps what to click and next. Thankx in advance

推荐答案

1）您可以使用脚本向导。 http：// www .mssqltips.com / sqlservertip / 2500 / sql-server-2008-r2-generate-scripts-wizard-with-database-schema-and-data / [ ^ ]

2）备份策略更适合处理此类情况。

1) You can use the script wizard. http://www.mssqltips.com/sqlservertip/2500/sql-server-2008-r2-generate-scripts-wizard-with-database-schema-and-data/[^]
2) A backup strategy would be more appropriate to handle such scenarios.

这篇关于如何从数据库生成脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！