SQL dump of the SQL Server database

To get this SQL Dump, follow this procedure, in SQL Server’s management interface:

  • Under SQL Server Management Studio, Right click on the database you want to export
  • Select Tasks/Generate Scripts
  • Click “Next” on the welcome screen (if it hasn’t already been desactivated)
  • Select your database
  • In the list of things you can export, just change “Script Indexes” from False to True, then “Next”
  • Select Tables then “Next”
  • Select the tables you want to export (or select all), then “Next”
  • Script to file, choose a filename, then “Next”
  • Select unicode encoding (who knows…, maybe someone has put accents in objects names, or in comments)
  • Finish

本文作者: GavinDong

版权属于: GavinDong博客

文章链接: https://gavindong.com/2628.html

如果使用过程中遇到问题,可 **点击此处** 交流沟通。

版权所有,转载时必须以链接形式注明作者和原始出处及本声明。

(0)

发表回复

登录后才能评论