Home > Database > Mysql Tutorial > body text

SQL Server2008导出数据生成文件

WBOY
Release: 2016-06-07 16:21:59
Original
1015 people have browsed it

1、选中要导出的数据库右键tasks(任务)Generate Script(生成脚本),进入脚本生成界面; 2、点下一步(默认选中需要导出的数据库)勾选复选框(Script all objects in the selected database),下一步 找到Script Data(编写数据脚本),将后面的值改为true,(PS:

   1、选中要导出的数据库——右键——tasks(任务)——Generate Script(生成脚本),,进入脚本生成界面;

  2、点“下一步”——(默认选中需要导出的数据库)勾选复选框(Script all objects in the selected database),下一步 ——找到“Script Data”(编写数据脚本),将后面的值改为true,(PS:注意选择数据库版本)下一步—— 选中生成脚本后保存的路径、编码等,下一步

  3、Finish(完成),在选择脚本文件保存路径下可以找到相应的脚本文件。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!