使用 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 !
clone database and rename
标签：