使用 management studio
right click database -> Tasks -> Generate Scripts -> next until "Set Scripting Options" -> Advance
Types of data to script 选择 Schema and data
Script Full-Text Indexes 选择 True
Script Triggers 选择 True
next -> finish
然后会生产 .sql file , open and rename database name then excute, done !
原文：http://www.cnblogs.com/keatkeat/p/5624938.html